Oracle list constraints

SELECT *
FROM ALL_CONSTRAINTS c,
     ALL_CONS_COLUMNS cols
WHERE c.CONSTRAINT_TYPE = 'P'
  AND c.CONSTRAINT_NAME = COLS.CONSTRAINT_NAME
  AND c.OWNER = COLS.OWNER
  AND c.OWNER = 'schema_name'
  AND cols.TABLE_NAME = 'table_name'
ORDER BY cols.TABLE_NAME, COLS.POSITION;

Similar codes

0 vote281 views1 answer
Create a table from one field of another table
SQL
5 votes263 views3 answers
String concatenation sql server
SQL
0 vote259 views1 answer
Sqlserver now
SQL
0 vote284 views1 answer
ORA-00942
SQL
0 vote258 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote286 views1 answer
How to start my sql server on mac
SQL
5 votes274 views1 answer
Oracle get foreign keys on table
SQL
1 vote266 views1 answer
Psql: FATAL: Ident authentication failed for user "postgres"
SQL
1 vote289 views3 answers
Mysql parse int
SQL
0 vote272 views1 answer
Sql show all users
SQL