Difference between revisions of "OE.ORDER 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.ORDER_TYP
 
| OE.ORDER_TYP
|-
 
 
|}
 
|}
 
  
 
=== Source ===
 
=== Source ===

Latest revision as of 07:15, 24 June 2010

wikibot[edit]

Type OE.ORDER_TYP

Source[edit]

CREATE OR REPLACE TYPE order_typ
                                         AS OBJECT
    ( order_id           NUMBER(12)
    , order_mode         VARCHAR2(8)
    , customer_ref  REF  customer_typ
    , order_status       NUMBER(2)
    , order_total        NUMBER(8,2)
    , sales_rep_id       NUMBER(6)
    , order_item_list    order_item_list_typ
    ) ;