File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Can we make any column in nested table as foreign key of a normal table primary key? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Can we make any column in nested table as foreign key of a normal table primary key?" Watch "Can we make any column in nested table as foreign key of a normal table primary key?" New topic
Author

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

Brahim Bakayoko
Ranch Hand

Joined: Aug 29, 2003
Posts: 155
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, <br />A+, MCP 2000 and 2000 server, CST, and few incompleted certification tracks.<br /> <br />Ivory Coast<br /> <br />Analyze your web Request/Response @ <a href="http://webtools.servehttp.com" target="_blank" rel="nofollow">http://webtools.servehttp.com</a> down for a while...
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Can we make any column in nested table as foreign key of a normal table primary key?