The Object Type Column Objects : Object Column « Object Oriented « Oracle PL/SQL Tutorial

A "column object" is an entity that can be used as a column in an Oracle table.

Column objects usually consist of columns defined with predefined types.

SQL> --CREATE a TABLE with the Column Type in It
SQL>
SQL> CREATE OR REPLACE TYPE ADDRESS_OBJ as OBJECT(
  2  street VARCHAR2(20),
  3  city VARCHAR2(20),
  4  state CHAR(2),
  5  zip CHAR(5))
  6  /

Type created.

SQL>
SQL> CREATE TABLE emp (
  2  empno NUMBER(3),
  3  name VARCHAR2(20),
  4  address ADDRESS_OBJ)
  5  /

Table created.

SQL>
SQL> drop table emp;

Table dropped.

SQL> drop type ADDRESS_OBJ;

Type dropped.

SQL>

32.7.Object Column
	32.7.1.	Using Object Types to Define Column Objects and Object Tables
	32.7.2.	You can use an object type to define an entire table, and the table is known as an object table.
	32.7.3.	The Object Type Column Objects
	32.7.4.	Loading the 'row object' Table
	32.7.5.	SELECT with a WHERE Clause
	32.7.6.	UPDATE Data in a Table of Row Objects
	32.7.7.	Using UPDATE with TYPEed Columns
	32.7.8.	Query a table with user-defined column type
	32.7.9.	Use * to reference all columns from a table
	32.7.10.	Use 'table of custom type' as table column type
	32.7.11.	Nested varray and table collection column
	32.7.12.	Create type and use it as table column
	32.7.13.	Nested type Column
	32.7.14.	Create a new type and add it to a table