What table is the Oracle query field

--The query field in what table

Select *  from where t.column_name='ABC';

--Query What table the field is in and determine if it is a primary key

Select *         fromAll_tab_cols T Left Join (         SelectA.table_name, A.constraint_name, A.column_name, B.constraint_type--field Constraint type (P: primary key)            fromUser_cons_columns aInner Joinuser_constraints b onA.constraint_name=B.constraint_name--and b.constraint_type = ' P ') TC on 1=1           andT.table_name=Tc.table_name andT.column_name=Tc.column_namewhere 1=1        andT.column_name=  'Pk_psndoc'--the field to query        andTc.constraint_type= 'P'  --determines whether the primary key       ORDER  byT.table_name

What table is the Oracle query field