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 vote323 views1 answer
Setval postgres example table id
SQL
0 vote272 views1 answer
Oracle sql developer script output limit
SQL
0 vote327 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
0 vote266 views1 answer
Sqlalchemy existing database
SQL
0 vote321 views1 answer
Oserror mysql_config not found virtualenv
SQL
0 vote333 views1 answer
QCompleter con sql
SQL
0 vote320 views1 answer
How to create a new shema using query languaage
SQL
1 vote322 views1 answer
Mysql is odd
SQL
1 vote321 views1 answer
Get last week data in mysql
SQL
2 votes316 views1 answer
Add 2 hours to current time in MySQL
SQL