OE.ORDER TYP (type)

From dbscript Online Help
Jump to: navigation, search

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
    ) ;