CREATE OR REPLACE TYPE phone_type AS object(
prefix VARCHAR2(5),
phonenumber VARCHAR2(25));
 /




CREATING:-



TYPE:- CREATE OR REPLACE TYPE [typename_type] AS OBJECT;

object TABLE:- CREATE TABLE [tablename] OF [typename_type];

varray :- CREATE TYPE [name_varray_type] AS VARRRAY(SIZE) OF [typename_type];


nested_table:- CREATE TYPE [tablename_table_type] AS TABLE OF [typename_type];





USING IN TABLES:-
TYPE(object COLUMN):- CREATE TABLE( ....., column_name typename_type,...);


object TABLE:- CREATE TABLE (...., column_name REF [typename_type] SCOPE IS [tablename(OBJECT TABLE)], ...);


varray:- CREATE TABLE( ....., column_name [name_varray_type],...);




#########
###### note:- tablename_table IS different than tablename_table_type. WHILE tablename has same VALUE i.e IF tablename_table_type = nice_table_type THEN tablename_table would be nice_table;############
########
nested TABLE:- CREATE TABLE relational_tablename(......, column_name [tablename_table_type], ...) NESTED TABLE [column_name] STORE AS [tablename_table];

############create TABLE test(id NUMBER(5), name VARCHAR2(34), phone_number phonenumber_table_type) nested TABLE phone_number store AS phonenumber_nested_table; #############
################################################
###############################################
###############################################




INSERTING INTO TABLES:-
TYPE(object_columns) :- INSERT INTO relational_table_name ([OBJECT_COLUMN_NAME]) VALUES(typename_type(value1, value2)); ### don't forget '' if varchar

object_table:- 2 STEPS:- 1: ### just like relational with type#### INSERT INTO object_table_name(columns) VALUES(typename_type(value1, value2));
                        2: INSERT INTO relational_table_name ([column],..., object_TABLE_REF_COLUMN) SELECT [VALUE],....,REF(ALIAS) FROM object_table_name ALIAS WHERE [object_table_column] = [object_table_column];



varray:- insert into relational_table_name ([OBJECT_COLUMN_NAME]) VALUES(typename_varray_type(typename_type(value1,                                                                                             value2..),typename_type(value1, value2..), .....));

nested table:- insert into relational_table_name ([OBJECT_COLUMN_NAME]) VALUES(typename_table_type(typename_type(value1,                                                                                            value2..),typename_type(value1, value2..), .....));