Create a table with nested user defined type as column : Object Table « Object Oriented Database « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Object Oriented Database
  3. Object Table

Create a table with nested user defined type as column

   
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>








Related examples in the same category

1.Crate table with object column
2.Use a table alias and the name of the object
3.Create table with user defined type as column
4.Create a table with user define varray as column type
5.Object table: a table of type
6.Use user-defined varray type as column type
7.Nested table
8.Create a table based on user-defined object only
9.Implementation of many to many using object references
10.Implementation of multiple inheritance relationship
11.Implementation of one to many using object references
12.Create table based on single data type
13.Create table with nested types
14.Create type and use it as table column
15.One to one using object references
16.Use user-defined type to combine query logic
17.Create a new type and add it to a table
18.Multilevel aggregation relationships using nested tables