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 vote354 views2 answers
Install mysqldump ubuntu
SQL
0 vote337 views2 answers
Mysql updating multiple column values from array variable
SQL
16 votes362 views1 answer
Mysql smallint range
SQL
2 votes380 views1 answer
Sql server check for value in multiple columns
SQL
0 vote367 views1 answer
Sql alchemy escape ; in insert statement
SQL
0 vote386 views1 answer
Netstat -tln mysql
SQL
0 vote378 views2 answers
Sql stored procedure for access frontend
SQL
0 vote368 views1 answer
Oracle date winter time
SQL
1 vote383 views3 answers
How to pass password to mysql command line
SQL
0 vote341 views1 answer
Postgresql conectar
SQL