Rem
Rem $Header: cdemodr3.sql 03-jun-97.18:20:35 azhao Exp $
Rem
Rem cdemodr3.sql
Rem
Rem  Copyright (c) Oracle Corporation 1997. All Rights Reserved.
Rem
Rem    NAME
Rem      cdemodr3.sql - setup for cdemodr3.c
Rem
Rem    DESCRIPTION
Rem      create type and table used for cdemodr3.c
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    azhao       06/03/97 - Created
Rem

connect scott/tiger

drop table extaddr;
drop type address_object;

create type address_object as object (state char(2), zip char(10));
create table extaddr of address_object;

quit

