Rem
Rem $Header: cdemodsa.sql 30-may-97.23:35:36 sgollapu Exp $
Rem
Rem cdemodsa.sql
Rem
Rem  Copyright (c) Oracle Corporation 1997. All Rights Reserved.
Rem
Rem    NAME
Rem      cdemodsa.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    azhao       06/03/97 - add connect scott/tiger
Rem    sgollapu    05/30/97 - Created
Rem

connect scott/tiger;

set echo on;

drop table customerobj;
drop type address_object;
drop type person;
drop table empnml;
drop table empref;

create type address_object as object (state char(2), zip char(10));
create table customerobj (custno number, addr REF address_object);

create type person as object(name char(20), age number, address address_object);
create table empnml (emp_id number, emp_info person);
create table empref (emp_id number, emp_info REF person);

commit;

set echo off;
