Mega Code Archive
Categories
/
Oracle PLSQL
/
Object Oriented Database
Create table with nested types
SQL> SQL> --CREATE [OR REPLACE] TYPE
AS TABLE OF (object schema) SQL> --/ SQL> --CREATE TABLE
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
SQL> -- (attribute attribute type, ...., SQL> -- outer nested item object table schema); SQL> -- NESTED TABLE
SQL> -- STORE AS
SQL> -- (NESTED TABLE
SQL> -- STORE AS
); 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>