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
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply 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?
 
Similar Threads
How to implement OneToOne entity without explicit id field
Composite foreign key mapping in Hibernate 3 using JPA
Generator class for non-primary columns
inserting data of two forms into two tables with same transaction id
hibernate mapping