Create table with nested types : Object Table « Object Oriented Database « Oracle PL / SQL

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

Create table with nested types

   
SQL>
SQL> --CREATE [OR REPLACE] TYPE <object table schema> AS TABLE OF (object schema)
SQL> --/
SQL> --CREATE TABLE <table schema>
SQL> --   (attribute        attribute type, ....,
SQL> --    attribute        attribute type,
SQL> --    nested item      object table schema);
SQL> --    NESTED TABLE nested item STORE AS storage table schema;
SQL>
SQL> --CREATE TABLE <table schema>
SQL> --   (attribute              attribute type, ....,
SQL> --    outer nested item      object table schema);
SQL> --   NESTED TABLE <outer nested item>
SQL> --      STORE AS <outer storage table schema>
SQL> --      (NESTED TABLE <inner nested item>
SQL> --         STORE AS <inner storage table schema>);
SQL>
SQL> --Example:
SQL>
SQL> CREATE OR REPLACE TYPE personType AS OBJECT
  2      (person_id        VARCHAR2(10),
  3       person_name      VARCHAR2(30))
  4      /

Type created.

SQL>
SQL>
SQL> CREATE OR REPLACE TYPE Person_Table AS TABLE OF personType
  2   /

Type created.

SQL>
SQL>
SQL>
SQL>
SQL> CREATE TABLE Course
  2      (course_id        VARCHAR2(10),
  3       course_name      VARCHAR2(20),
  4       Programmer         Person_Table)
  5       NESTED TABLE Programmer STORE AS Person_tab;

Table created.

SQL>
SQL>
SQL>
SQL>
SQL> drop table course;

Table dropped.

SQL>
SQL>
SQL>

   
    
    
  

Related examples in the same category