Difference between revisions of "OE.XDBPO TYPE (type)"
(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 |
| OE.XDBPO_TYPE | | OE.XDBPO_TYPE | ||
− | |||
|} | |} | ||
+ | === Source === | ||
<pre> | <pre> | ||
− | CREATE TYPE | + | 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