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

8 votes271 views2 answers
Sqlsrv default port
SQL
1 vote326 views1 answer
Difference between where and having clause
SQL
0 vote266 views1 answer
Logtash mysql cofiguration file
SQL
0 vote245 views2 answers
How to find max and min salary in sql
SQL
23 votes274 views4 answers
Uninstall postgresql ubuntu
SQL
1 vote251 views2 answers
Mysql join two tables
SQL
0 vote270 views1 answer
Adding generated time in row mysql workbench
SQL
3 votes253 views1 answer
Ms sql skip take
SQL
0 vote249 views1 answer
Sql server python connection
SQL
2 votes260 views1 answer
SQL IF ELSE
SQL