Skip to Main Content

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 18 2013
Added on Sep 19 2013
13 comments
3,017 views