|
|
| (One intermediate revision 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 |
| | | IX.ORDER_EVENT_TYP | | | IX.ORDER_EVENT_TYP |
| − | |-
| |
| | |} | | |} |
| − |
| |
| | | | |
| | === Source === | | === Source === |
| Line 21: |
Line 19: |
| | ); | | ); |
| | </pre> | | </pre> |
| − |
| |
| − | === Dependencies ===
| |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |- style="background:silver"
| |
| − | | '''Reference Type
| |
| − | | '''Object Type
| |
| − | | '''Referencing Object
| |
| − |
| |
| − | |-
| |
| − | | Data Type
| |
| − | | Table
| |
| − | | [[IX.ORDERS_QUEUETABLE_(table)|IX.ORDERS_QUEUETABLE]]
| |
| − |
| |
| − | |}
| |
Latest revision as of 11:34, 27 August 2011
wikibot[edit]
CREATE OR REPLACE TYPE "ORDER_EVENT_TYP" AS OBJECT (
order_id NUMBER(12),
product_id NUMBER(6),
customer_id NUMBER(6),
cust_first_name VARCHAR2(20),
cust_last_name VARCHAR2(20),
order_status NUMBER(2),
delivery_date DATE
);
