Re: Can I create a table with a column containing varied-size objectsin Oracle?

I think this is what you are describing (coded under 8.0.4):

create type page as object (v1 varchar2(20)); /

create type pages as table of page;
/

create type book as object (id number(3), contents pages); /

create table books of book
nested table contents store as contents_table;

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Jzhou wrote in message ...
>
>Similar to STL template datatypes, I want to use a OO-database which
>permits to store a list of objects under one table column. The size of the
>list is dynamic (For example, there is a table with two columns: id and
>Book. And there is an object type PAGE. 1st row - id column contains 1,
>Book column contains 3 PAGE objects. 2nd row - id column contains 2, Book
>column contains 5 PAGE objects.) Is there such OO_database exist?
>If not, can I build such a database?
>
>Thanks.
>
>Jing
>
Received on Sun Aug 01 1999 - 03:54:53 CDT