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!

Find table name and constraint type based on field name

1016450Sep 19 2013 — edited Sep 20 2013

I have a field or column name with me...I want to find the table name for which it is a primary key...Any query to do this job so that the execution costs are low...

Currently i have to mix dba_constraints and ALL_TAB_COLUMNS to get this...any way to fetch the data from a single table/anyother cost effective process is appreciated

This post has been answered by Karthick2003 on Sep 19 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 18 2013

Added on Sep 19 2013

13 comments

3,037 views