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

Home -> Community -> Usenet -> c.d.o.server -> Re: References in Nested Tables

Re: References in Nested Tables

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 6 Jan 2000 11:08:45 -0000
Message-ID: <947157115.15407.0.nnrp-07.9e984b29@news.demon.co.uk>


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

Original text of this message

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