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 vote408 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
3 votes365 views1 answer
Sql insert inserted id
SQL
0 vote369 views1 answer
Stored procedures example
SQL
0 vote345 views1 answer
Sql recherche nom prenom
SQL
2 votes346 views1 answer
Get first n letter of department name in sql
SQL
1 vote352 views1 answer
Md5 encryption for existing records
SQL
0 vote351 views2 answers
Get top 1 row of each group
SQL
0 vote339 views1 answer
Find all tables where column name exists oracle
SQL
1 vote353 views2 answers
How to check if sql query is correct online
SQL
0 vote404 views1 answer
Sql query to select even numbers
SQL