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