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 vote333 views1 answer
How to get data between a last week in mysql
SQL
0 vote378 views1 answer
Error code 1451 sql
SQL
0 vote354 views1 answer
Check connections to database postgres
SQL
4 votes339 views1 answer
Refresh postgres config
SQL
0 vote379 views1 answer
Mysql get first 2 characters of string
SQL
0 vote339 views2 answers
How to generate a unique random number in mysql
SQL
0 vote333 views1 answer
Oracle free up space in tablespace
SQL
0 vote374 views1 answer
Postgresql print sessions using the database
SQL
0 vote329 views1 answer
Events not working db
SQL
3 votes341 views2 answers
Mysql import gz
SQL