OE.ORDER ITEM TYP (type)

From dbscript Online Help
Jump to: navigation, search

wikibot[edit]

Type OE.ORDER_ITEM_TYP

Source[edit]

CREATE OR REPLACE TYPE order_item_typ
                                         AS OBJECT
    ( order_id           NUMBER(12)
    , line_item_id       NUMBER(3)
    , unit_price         NUMBER(8,2)
    , quantity           NUMBER(8)
    , product_ref  REF   product_information_typ
    ) ;