SELECT
col.column_name
FROM
user_constraints con,user_cons_columns col
WHERE
con.constraint_name=col.constraint_name and con.constraint_type='P'
and col.table_name='EMP';
SELECT
col.column_name
FROM
user_constraints con,user_cons_columns col
WHERE
con.constraint_name=col.constraint_name and con.constraint_type='P'
and col.table_name='EMP';