Re: Creating nested tables

From: Daniel Roy <danielroy10_at_hotmail.com>
Date: 4 Feb 2003 09:43:03 -0800
Message-ID: <1b061893.0302040943.70aab02e@posting.google.com>

Interesting homework :)

Works in my Oracle 8.1.6:

CREATE TYPE dog_info_type as object (

Dog_id NUMBER,
Dog_breed VARCHAR2(40),
Dog_birthdate DATE);

create type dog_info_array_type as table of dog_info_type;
/

create table dog_owners (
Name VARCHAR2(40),
Address VARCHAR2(60),
Dog_name VARCHAR2(40),
Dog_info dog_info_array_type)
nested table Dog_info store as X_Array_Data ( (PRIMARY KEY (nested_table_id, dog_id))
ORGANIZATION INDEX); Daniel Received on Tue Feb 04 2003 - 11:43:03 CST