Difference between revisions of "OE.XDBPO 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_TYPE |- |} <pre> CREATE TYPE OE.XDBPO_TYPE FROM NOT NULL </pre>)
 
 
(2 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
| '''type
+
| '''Type
 
| OE.XDBPO_TYPE
 
| OE.XDBPO_TYPE
|-
 
 
|}
 
|}
  
 +
=== Source ===
 
<pre>
 
<pre>
CREATE TYPE OE.XDBPO_TYPE FROM  NOT NULL
+
CREATE OR REPLACE TYPE     "XDBPO_TYPE" AS OBJECT ("SYS_XDBPD$" "XDB"."XDB$RAW_LIST_T","Reference" VARCHAR2(30 CHAR),"ACTIONS" "XDBPO_ACTIONS_TYPE","REJECTION" "XDBPO_REJECTION_TYPE","Requestor" VARCHAR2(128 CHAR),"EmployeeID" NUMBER(38),"DepartmentID" VARCHAR2(4 CHAR),"SHIPPINGINSTRUCTIONS" "XDBPO_SHIPINSTRUCTIONS_TYPE","SpecialInstructions" VARCHAR2(2048 CHAR),"LINEITEMS" "XDBPO_LINEITEMS_TYPE")FINAL INSTANTIABLE
 
</pre>
 
</pre>

Latest revision as of 07:16, 24 June 2010

wikibot[edit]

Type OE.XDBPO_TYPE

Source[edit]

CREATE OR REPLACE TYPE      "XDBPO_TYPE" AS OBJECT ("SYS_XDBPD$" "XDB"."XDB$RAW_LIST_T","Reference" VARCHAR2(30 CHAR),"ACTIONS" "XDBPO_ACTIONS_TYPE","REJECTION" "XDBPO_REJECTION_TYPE","Requestor" VARCHAR2(128 CHAR),"EmployeeID" NUMBER(38),"DepartmentID" VARCHAR2(4 CHAR),"SHIPPINGINSTRUCTIONS" "XDBPO_SHIPINSTRUCTIONS_TYPE","SpecialInstructions" VARCHAR2(2048 CHAR),"LINEITEMS" "XDBPO_LINEITEMS_TYPE")FINAL INSTANTIABLE