OE PRODUCT_INFORMATION_TYP (type)

Modified on 2011/08/27 12:10 by wikibot Categorized as Uncategorized

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Type'''
| OE.PRODUCT_INFORMATION_TYP
|}

=== Source ===
{{{{<nowiki>
CREATE OR REPLACE TYPE product_information_typ
                                         AS OBJECT
    ( product_id           NUMBER(6)
    , product_name         VARCHAR2(50)
    , product_description  VARCHAR2(2000)
    , category_id          NUMBER(2)
    , weight_class         NUMBER(1)
    , warranty_period      INTERVAL YEAR(2) TO MONTH
    , supplier_id          NUMBER(6)
    , product_status       VARCHAR2(20)
    , list_price           NUMBER(8,2)
    , min_price            NUMBER(8,2)
    , catalog_url          VARCHAR2(50)
    , inventory_list       inventory_list_typ
    ) ;
</nowiki>}}}}

devio dbscript ScrewTurn Wiki

Navigation¶

OE PRODUCT_INFORMATION_TYP (type)