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 vote214 views1 answer
Sql select min row
SQL
11 votes235 views1 answer
How to get ddl for materialized view
SQL
0 vote187 views1 answer
Flask sqlalchemy update row
SQL
0 vote190 views1 answer
Formatting code with SQL Developer
SQL
1 vote225 views1 answer
Mysql view curren querys
SQL
0 vote201 views1 answer
GROUP BY postgres
SQL
1 vote263 views1 answer
Autocommit mysql
SQL
1 vote220 views3 answers
Psql fatal database does not exist
SQL
13 votes254 views3 answers
Mysqldump structure only
SQL
0 vote227 views1 answer
Select top 3 sql
SQL