Create type and use it as table column : Object Column « Object Oriented « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Object Oriented
  3. Object Column
SQL> create or replace type addressType as object
  2  (
  3      Street   VARCHAR2(50),
  4      City      VARCHAR2(25),
  5      State     CHAR(2),
  6      Zip       NUMBER
  7  );
  8  /
SQL> create table CUSTOMER
  2  (
  3      Name     VARCHAR2(25),
  4      Address   addressType
  5  );
SQL> /



SQL> insert into CUSTOMER values(1,addressType('My Street', 'Some City', 'ST', 10001));
SQL>
SQL> drop type addressType force;
SQL> drop table customer;








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