Tables And Thier Primary Key Columns

select C1.TABLE_NAME TABLE_NAME,C1.COLUMN_NAME COLUMN_NAME,C2.CONSTRAINT_TYPE CONSTRAINT_TYPE
from USER_CONS_COLUMNS C1,USER_CONSTRAINTS C2
where C1.CONSTRAINT_NAME =C2.CONSTRAINT_NAME
AND C2.CONSTRAINT_TYPE='P'