Difference between revisions of "OE.INVENTORY TYP (type)"

From dbscript Online Help
Jump to: navigation, search
Line 3: Line 3:
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|-
 
|-
| '''type
+
| '''Type
 
| OE.INVENTORY_TYP
 
| OE.INVENTORY_TYP
 
|-
 
|-
Line 9: Line 9:
  
  
 +
=== Source ===
 
<pre>
 
<pre>
 
CREATE OR REPLACE TYPE inventory_typ
 
CREATE OR REPLACE TYPE inventory_typ

Revision as of 09:28, 11 February 2010

wikibot

Type OE.INVENTORY_TYP


Source

CREATE OR REPLACE TYPE inventory_typ
                                         AS OBJECT
    ( product_id          NUMBER(6)
    , warehouse           warehouse_typ
    , quantity_on_hand    NUMBER(8)
    ) ;