Skip Headers

Oracle® Objects for OLE Developer's Guide
10g Release 1 (10.1)

Part Number B10118-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Feedback

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);