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 vote395 views1 answer
Get last inserted primary key
SQL
8 votes352 views1 answer
Show mysql user table
SQL
0 vote375 views1 answer
View t-sql mail configuration
SQL
1 vote336 views1 answer
How to select random rows from table
SQL
0 vote341 views1 answer
Selects all the columns from the sailors table
SQL
0 vote353 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
0 vote381 views1 answer
Sql server insert inner join
SQL
0 vote352 views1 answer
Month mysql
SQL
1 vote364 views2 answers
Regex starts with
SQL
7 votes386 views1 answer
Query postgres delete duplicates
SQL