Re: detect primaryKeys for nested Tables

From: The Ghost <The>
Date: Wed, 26 Sep 2001 03:46:15 GMT
Message-ID: <bccs7.41746$g45.20249332_at_news3.rdc2.on.home.com>


"You" define the primary keys to suit the business rules.

"Carsten" <fehlen_at_t-online.de> wrote in message news:95b0338f.0109250708.4652e66b_at_posting.google.com...
> Hi!
> i found the following example for a nested table:
>
> CREATE TYPE ProjectType AS
 ECT(
> pno NUMBER,
> pname CHAR(31),
> budget NUMBER);
> CREATE TYPE ProjectSet AS TABLE OF ProjectType;
>
> CREATE TABLE Dept (dno NUMBER, dname CHAR(31), projs ProjectSet)
> NESTED TABLE projs STORE AS
> ProjectSetTable ((Primary Key(Nested_Table_Id, pno))
> ORGANIZATION
> INDEX COMPRESS 1);
>
> My Question is: how can i find out the primaryKey-Columns?
> I am building an application that should show that these columns (in
> this case 'nested_table_id' and 'pno' are primaryKeys.
> I have the other data of the nested table (via the ALL_NESTED_TABLES -
> table) but i dont know where i can the information about the
> primaryKeys.
> Plz help,
> Carsten
Received on Wed Sep 26 2001 - 05:46:15 CEST

Original text of this message