Re: Creating nested tables

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Tue, 04 Feb 2003 17:28:31 GMT
Message-ID: <3LS%9.327$XC4.241@newssvr16.news.prodigy.com>

Hassan Masri wrote:
> Hi
>
> I have a question regarding nested tables: Mainly my question is: How
> do you create them? I looked in books and didn't really find anything.
> What I found:
>
> CREATE TYPE dog_info_table (
> Dog_id NUMBER,
> Dog_breed VARCHAR2(40),
> Dog_birthdate DATE);
>
> CREATE TABLE dog_owners (
> Name VARCHAR2(40),
> Address VARCHAR2(60),
> Dog_name VARCHAR2(40),
> Dog_info dog_info_table);
>
> didn't work with me. The SQL command just didn't want to execute. I am
> working with Oracle 8i.
>
> thanks
> hassan

Don't know what books you looked in. I think your problem is one of syntax. The following worked for me in 8i:

CREATE TYPE dog_info_table as object (

   Dog_id NUMBER,
   Dog_breed VARCHAR2(40),
   Dog_birthdate DATE

)
/

CREATE TABLE dog_owners (

   Name VARCHAR2(40),
   Address VARCHAR2(60),
   Dog_name VARCHAR2(40),
   Dog_info dog_info_table
)
/ Received on Tue Feb 04 2003 - 11:28:31 CST