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 vote235 views2 answers
Mysql password error create datbase
SQL
4 votes258 views6 answers
List all tables in postgres
SQL
1 vote243 views1 answer
T-sql find object by name
SQL
0 vote237 views1 answer
Inserted row count tsql
SQL
0 vote257 views1 answer
Get statis values sql
SQL
2 votes245 views1 answer
Use cases condition in sql query laravel
SQL
3 votes493 views1 answer
Postgresql cast
SQL
0 vote239 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
0 vote240 views1 answer
Alter database name script
SQL
0 vote255 views1 answer
Savepoint mysql script
SQL