Difference between revisions of "OE.XDBPO PART TYPE (type)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''type | OE.XDBPO_PART_TYPE |- |} <pre> CREATE TYPE OE.XDBPO_PART_TYPE FROM NOT NULL <...)
 
Line 7: Line 7:
 
|-
 
|-
 
|}
 
|}
 +
  
 
<pre>
 
<pre>
CREATE TYPE OE.XDBPO_PART_TYPE FROM  NOT NULL
+
CREATE OR REPLACE TYPE     "XDBPO_PART_TYPE" AS OBJECT ("SYS_XDBPD$" "XDB"."XDB$RAW_LIST_T","PARTNO" VARCHAR2(14 CHAR),"Quantity" NUMBER(12,2),"UNITPRICE" NUMBER(8,4))FINAL INSTANTIABLE
 
</pre>
 
</pre>

Revision as of 21:12, 24 August 2009

wikibot

type OE.XDBPO_PART_TYPE


CREATE OR REPLACE TYPE      "XDBPO_PART_TYPE" AS OBJECT ("SYS_XDBPD$" "XDB"."XDB$RAW_LIST_T","PARTNO" VARCHAR2(14 CHAR),"Quantity" NUMBER(12,2),"UNITPRICE" NUMBER(8,4))FINAL INSTANTIABLE