Re: Creating nested tables

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Tue, 04 Feb 2003 08:21:10 -0800
Message-ID: <3E3FE876.2BEEB61@exesolutions.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
> --
> Dejvicka. Upozorneni pro cestujici - stanice metra je uzavrena.
> Pristi zastavka Thakurova

You can find examples at http://tahiti.oracle.com

Daniel Morgan Received on Tue Feb 04 2003 - 10:21:10 CST