File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Oracle/OAS and the fly likes Multiple columns having same foreign key Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Multiple columns having same foreign key" Watch "Multiple columns having same foreign key" New topic
Author

Multiple columns having same foreign key

Jayavardhan geepi
Ranch Hand

Joined: Jul 21, 2010
Posts: 66
Hi..

In a table I have 2 columns which must refer to same column of another table.

while Executing alter table query for 2nd column it says such a constraint already exists.

Can some one help.. Is this possible?
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3610
    
  60

Yes, it should be possible, like this:
Post your script and error messages if you cannot resolve it.
 
Don't get me started about those stupid light bulbs.
 
subject: Multiple columns having same foreign key