SQL>
SQL> create type order_item_type as object (
2 line_item_id number(3),
3 product_id number(6),
4 unit_price number(8,2),
5 quantity number(4)
6 )
7 /
Type created.
SQL>
SQL>
SQL> create type order_item_list_type as table of order_item_type
2 /
Type created.
SQL>
SQL>
SQL> create table orders(
2 order_id number(12) not null,
3 order_date timestamp(6) with local time zone,
4 customer_id number(6),
5 order_items order_item_list_type )
6 nested table order_items store as order_items_tab
7 /
Table created.
SQL>
SQL> drop table orders;
Table dropped.
SQL> drop type order_item_list_type;
Type dropped.
SQL> drop type order_item_type;
Type dropped.
SQL>
|