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 vote283 views1 answer
Where name ends in SQL
SQL
0 vote288 views2 answers
Nosqlbooster query other collection
SQL
5 votes303 views1 answer
Sql integer to serial
SQL
2 votes272 views1 answer
Import large .sql files into lampp
SQL
0 vote300 views1 answer
How to get one year old query from plan cache
SQL
8 votes290 views1 answer
Oracle create datafile
SQL
11 votes712 views4 answers
Reset identity column values in sql server
SQL
0 vote279 views1 answer
Pass array parameter to stored procedure c#
SQL
0 vote306 views1 answer
Postgre query date
SQL
0 vote270 views1 answer
How to install mysql without admin rights
SQL