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 vote144 views1 answer
How to get nth number in sql
SQL
0 vote120 views1 answer
Java input type sql date
SQL
1 vote136 views2 answers
Snowflake alter column data type
SQL
4 votes120 views2 answers
Postgres update single column
SQL
2 votes139 views2 answers
Sql strip non alphanumeric characters
SQL
0 vote149 views1 answer
Using distinct and count together in sql
SQL
0 vote132 views1 answer
Mysql count by month
SQL
14 votes140 views6 answers
Auto_increment mysql
SQL
17 votes149 views6 answers
MySQL ORDER BY
SQL
3 votes148 views1 answer
Oracle sql commit example
SQL