Difference between revisions of "OE.CUSTOMER TYP (type)"

From dbscript Online Help
Jump to: navigation, search
 
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
 
| '''Type
 
| '''Type
 
| OE.CUSTOMER_TYP
 
| OE.CUSTOMER_TYP
|-
 
 
|}
 
|}
 
  
 
=== Source ===
 
=== Source ===

Latest revision as of 07:15, 24 June 2010

wikibot[edit]

Type OE.CUSTOMER_TYP

Source[edit]

CREATE OR REPLACE TYPE customer_typ
 AS OBJECT
    ( customer_id        NUMBER(6)
    , cust_first_name    VARCHAR2(20)
    , cust_last_name     VARCHAR2(20)
    , cust_address       cust_address_typ
    , phone_numbers      phone_list_typ
    , nls_language       VARCHAR2(3)
    , nls_territory      VARCHAR2(30)
    , credit_limit       NUMBER(9,2)
    , cust_email         VARCHAR2(30)
    , cust_orders        order_list_typ
    )
NOT FINAL;