Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Creating nested tables

Creating nested tables

From: Hassan Masri <hmasri_at_web.de>
Date: Tue, 04 Feb 2003 11:16:28 +0100
Message-ID: <nb4v3vclio2cf2rsqt4kj8kkdb1po7v592@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

-- 
Dejvicka. Upozorneni pro cestujici - stanice metra je uzavrena.
Pristi zastavka Thakurova
Received on Tue Feb 04 2003 - 04:16:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US