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

1 vote170 views1 answer
Spark sql concatenate string and int
SQL
0 vote170 views1 answer
How to check oracle index table
SQL
4 votes196 views4 answers
Mysql get date from datetime
SQL
7 votes207 views2 answers
Phpmyadmin change password
SQL
0 vote158 views1 answer
Sql date d'aujourd'hui
SQL
0 vote165 views1 answer
Test connection to sql server
SQL
0 vote178 views3 answers
Condition in count sql
SQL
0 vote181 views1 answer
Make parameters nullable in sql server
SQL
7 votes171 views1 answer
Connect mysql docker
SQL
0 vote201 views1 answer
Convert LDAP Epoch to Date
SQL