Difference between revisions of "OE.XDBPO TYPE (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.XDBPO_TYPE
 
| OE.XDBPO_TYPE
 
|-
 
|-
Line 9: Line 9:
  
  
 +
=== Source ===
 
<pre>
 
<pre>
 
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  
 
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>

Revision as of 09:29, 11 February 2010

wikibot

Type OE.XDBPO_TYPE


Source

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