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 vote275 views1 answer
How to find top 3 salary in sql
SQL
7 votes329 views2 answers
Sql remove duplicates based on column
SQL
0 vote290 views1 answer
Install squirrel sql ubuntu
SQL
0 vote308 views1 answer
Shrink database file in sql server
SQL
0 vote290 views1 answer
Distinct data types in a table sql query
SQL
5 votes298 views3 answers
Mysql remove unique constraint
SQL
0 vote294 views1 answer
Second Step in installing SQL workbench
SQL
13 votes278 views4 answers
Mysql select last 10 rows
SQL
0 vote311 views1 answer
Oarcale list objects
SQL
1 vote333 views1 answer
Oracle columns table
SQL