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 vote191 views1 answer
Restore backup "text" postgresql command line
SQL
4 votes205 views1 answer
Data types in sql
SQL
1 vote306 views1 answer
Sql server delete top 1000
SQL
0 vote279 views1 answer
MySQL - How to find word with the most similar beginning
SQL
0 vote194 views1 answer
How to search query in python3 sqlite3
SQL
6 votes207 views2 answers
Postgresql database url
SQL
0 vote202 views2 answers
Sql server Insert Into table
SQL
0 vote199 views1 answer
Sql row number in result set
SQL
16 votes224 views1 answer
Mssql int max value
SQL
0 vote189 views1 answer
Using GROUP BY in MySQL Join Table
SQL