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 vote264 views1 answer
SQL server select to get sum of hours
SQL
-1 vote288 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
0 vote315 views1 answer
Sqlite insert or update
SQL
4 votes353 views4 answers
Remove duplicate old value in mysql
SQL
1 vote283 views1 answer
Trigger in postgresql to change incoming entry
SQL
4 votes293 views2 answers
Select first and last row mysql
SQL
14 votes318 views2 answers
Oracle add attribute to table
SQL
0 vote317 views1 answer
Sql server alter table add column tinyint
SQL
0 vote336 views1 answer
Fetching data from mysqldb
SQL
1 vote327 views3 answers
Read all columns of a table sql
SQL