OE.ORDER TYP (type)

From dbscript Online Help
Revision as of 20:11, 24 August 2009 by Bot (talk | contribs)
Jump to: navigation, search

wikibot

type OE.ORDER_TYP


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