Oracle list primary key

-- Primary key in a table
SELECT * FROM ALL_CONSTRAINTS 		-- or DBA_CONSTRAINTS or UESR_CONSTRAINTS
WHERE TABLE_NAME= 'table_name' AND CONSTRAINT_TYPE = 'P';
-- With columns names:
SELECT c.OWNER, c.TABLE_NAME, c.CONSTRAINT_NAME, c.CONSTRAINT_TYPE, 
	col.COLUMN_NAME
FROM ALL_CONSTRAINTS c
JOIN ALL_CONS_COLUMNS col ON c.TABLE_NAME = col.TABLE_NAME 
    AND c.CONSTRAINT_NAME = col.CONSTRAINT_NAME
WHERE c.TABLE_NAME= 'table_name' AND c.CONSTRAINT_TYPE = 'P'
ORDER BY c.TABLE_NAME, c.CONSTRAINT_NAME, col.COLUMN_NAME;

Similar codes

0 vote168 views1 answer
Postgresql log
SQL
0 vote175 views1 answer
T sql less than date
SQL
0 vote187 views1 answer
Query for backup a database at another location in file system
SQL
0 vote128 views1 answer
Sql table to store status
SQL
0 vote163 views2 answers
SQL FROM
SQL
0 vote165 views1 answer
Check if record exists mysql
SQL
0 vote178 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
0 vote159 views1 answer
Sql offfset
SQL
0 vote171 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
0 vote167 views1 answer
SQL loop with cursor
SQL