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

2 votes146 views1 answer
Postgresql transaction
SQL
0 vote120 views2 answers
Clear window pl sql
SQL
1 vote133 views1 answer
Search for tables with name postgresql
SQL
0 vote129 views1 answer
Oracle drop default value
SQL
0 vote86 views1 answer
Postgresql subquery
SQL
0 vote145 views1 answer
Play framework connection via windows sql server
SQL
0 vote128 views1 answer
SAP Return
SQL
1 vote177 views1 answer
Sqlite show columns in table
SQL
0 vote138 views1 answer
Ver usuarios mysql
SQL
0 vote142 views2 answers
How to get the date from datetime in mysql
SQL