|
|
Line 19: |
Line 19: |
| ); | | ); |
| </pre> | | </pre> |
− |
| |
− | === Dependencies ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Reference Type
| |
− | | '''Object Type
| |
− | | '''Referencing Object
| |
− |
| |
− | |- valign="top"
| |
− | | 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
);