Re: References in Nested Tables

Jonathan Lewis wrote in message
<947154995.24111.0.nnrp-04.9e984b29_at_news.demon.co.uk>...
>
>Problems:
> Can't create an index on a REF, so no rapid access
>

Unless it is SCOPED, of course -

e.g.
create type address as object (.....)

create type ref_address as object (address_ref ref address)

create type address_list as table of ref_address

create table addresses of address;

create table person(

    id number,
    name varchar2(30),
    add_list address_list
)
nested table add_list store as t_add_list;

Alter table t_add_list add (scope for (address_ref) is addresses); create index tal_i on t_add_list(address_ref);

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk Received on Thu Jan 06 2000 - 05:08:45 CST