Example: Schema Description used in examples of OraObject/OraRef

The following schema objects are used in the OraObject and OraRef examples. Data for the following tables can be inserted with the ORAEXAMP.SQL script that is provided with the OO4O installation.

CREATE TYPE address AS OBJECT (

street VARCHAR2(200),

city VARCHAR2(200),

state CHAR(2),

zip VARCHAR2(20)

);

CREATE TYPE person as OBJECT(

name VARCHAR2(20),

age NUMBER,

addr ADDRESS);

CREATE TABLE person_tab of PERSON;

CREATE TABLE customers(

account NUMBER,

aperson REF PERSON);