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 vote172 views4 answers
Postgresql between month
SQL
1 vote171 views2 answers
Sql server backup table
SQL
0 vote175 views1 answer
Hibernate with springboot mysql
SQL
2 votes128 views1 answer
Foreign key example in dbms
SQL
0 vote355 views1 answer
Get first match in each group mysql query
SQL
0 vote179 views1 answer
Sqlite insert or update
SQL
9 votes170 views4 answers
Mysql show table fields
SQL
2 votes162 views3 answers
Postgres remove foreign key constraint
SQL
0 vote319 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
0 vote172 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL