Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Creating nested tables
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 ThakurovaReceived on Tue Feb 04 2003 - 04:16:28 CST
![]() |
![]() |