Oracle Objects for OLE
Release 9.2

Part Number A95895-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

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


 
Oracle
Copyright © 1994, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback