SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Determine if database view column is foreign key in underlying table

Avi AbramiAug 4 2006 — edited Aug 6 2006

Hi,
I have posted this same question to the Database - General and JDBC forums.

I am using Oracle database 10g (10.1.0.4.0 - 64 bit production) standard edition on Red Hat Enterprise Linux AS release 3, JDK 1.4.2 and the latest Oracle JDBC (thin) driver.

We have a java GUI application that is a front-end for our database. Some of the data entry screens display data from database views. If a column in the view is a foreign key in the underlying table, we want to display a combo-box with the valid values so that the user can choose a correct value.

Is there some way to know whether a column in a view is a foreign key in the view's underlying table?

Thanks,
Avi.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 3 2006

Added on Aug 4 2006

12 comments

459 views