SELECT UC.TABLE_NAME, UCC.COLUMN_NAME
FROM USER_CONSTRAINTS UC, USER_CONS_COLUMNS UCC
WHERE UC.CONSTRAINT_NAME = UCC.CONSTRAINT_NAME
AND UC.TABLE_NAME = UPPER('DEMO_USER')
AND CONSTRAINT_TYPE = 'P'
SELECT *
FROM user_tab_columns
where table_name = 'DEMO_USER'
FROM USER_CONSTRAINTS UC, USER_CONS_COLUMNS UCC
WHERE UC.CONSTRAINT_NAME = UCC.CONSTRAINT_NAME
AND UC.TABLE_NAME = UPPER('DEMO_USER')
AND CONSTRAINT_TYPE = 'P'
SELECT *
FROM user_tab_columns
where table_name = 'DEMO_USER'