wikibot[edit]
CREATE OR REPLACE TYPE order_typ
AS OBJECT
( order_id NUMBER(12)
, order_mode VARCHAR2(8)
, customer_ref REF customer_typ
, order_status NUMBER(2)
, order_total NUMBER(8,2)
, sales_rep_id NUMBER(6)
, order_item_list order_item_list_typ
) ;