OE.CUSTOMER TYP (type)

From dbscript Online Help
Revision as of 21:03, 24 August 2009 by Bot (talk | contribs)
Jump to: navigation, search

wikibot

type OE.CUSTOMER_TYP


CREATE OR REPLACE TYPE customer_typ
 AS OBJECT
    ( customer_id        NUMBER(6)
    , cust_first_name    VARCHAR2(20)
    , cust_last_name     VARCHAR2(20)
    , cust_address       cust_address_typ
    , phone_numbers      phone_list_typ
    , nls_language       VARCHAR2(3)
    , nls_territory      VARCHAR2(30)
    , credit_limit       NUMBER(9,2)
    , cust_email         VARCHAR2(30)
    , cust_orders        order_list_typ
    )
NOT FINAL;