Can we make any column in nested table as foreign key of a normal table primary key?

Ranch Hand

Posts: 155

posted 21 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Can we make any column in nested table as foreign key of a normal table primary key?

I know how to set a nested table column as a primary key:
NESTED TABLE Specs STORE AS nested_table_specs((PRIMARY KEY(NESTED_TABLE_ID, SpecID, ...)))

How is it done for foreign keys?

SCJP, SCWCD, SCBCD, IBM CSD WebSphere v5, A+, MCP 2000 and 2000 server, CST, and few incompleted certification tracks. Ivory Coast Analyze your web Request/Response @ <a href="http://webtools.servehttp.com" target="_blank" rel="nofollow">http://webtools.servehttp.com</a>; down for a while...

First, you drop a couch from the plane, THEN you surf it. Here, take this tiny ad with you:

Clean our rivers and oceans from home

https://www.kickstarter.com/projects/paulwheaton/willow-feeders