|
|
Line 17: |
Line 17: |
| ); | | ); |
| </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
| |
− | | [[OE.CUSTOMERS_(table)|OE.CUSTOMERS]]
| |
− |
| |
− | |}
| |
Latest revision as of 11:34, 27 August 2011
wikibot[edit]
CREATE OR REPLACE TYPE "CUST_ADDRESS_TYP" AS OBJECT
( street_address VARCHAR2(40)
, postal_code VARCHAR2(10)
, city VARCHAR2(30)
, state_province VARCHAR2(10)
, country_id CHAR(2)
);