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 vote223 views1 answer
Mssql + bit + in python orm
SQL
3 votes196 views1 answer
Sql replace character in string in all records
SQL
0 vote221 views1 answer
<sql:datasource var="Snapsho"
SQL
1 vote222 views2 answers
Regex starts with
SQL
0 vote220 views1 answer
Sqlite get date only
SQL
10 votes254 views4 answers
Sql server pagination
SQL
0 vote204 views2 answers
Postgresql create role
SQL
11 votes209 views2 answers
Safe mode off mysql
SQL
0 vote228 views1 answer
Select multiple row from primary key sql
SQL
2 votes238 views2 answers
Postgres timestamp to datetime
SQL