Re: Creating nested tables

Here is a simple example:

create or replace type address_o as object (season varchar2(10), address varchar2(100));
/
create or replace type address_t as table of address_o; /
create or replace type nT_type as object (name varchar2(30), address address_t);
/
create table home of nt_type
nested table address store as home_table;

• Jusung Yang

Hassan Masri <hmasri_at_web.de> wrote in message news:<nb4v3vclio2cf2rsqt4kj8kkdb1po7v592_at_4ax.com>...
> 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
Received on Tue Feb 04 2003 - 15:10:31 CST