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 vote147 views1 answer
Alter database name script
SQL
2 votes123 views1 answer
Sql find missing values between two tables
SQL
0 vote121 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
0 vote123 views1 answer
Oarcale list objects
SQL
11 votes135 views2 answers
Mysql disable safe mode
SQL
0 vote119 views1 answer
Case when with count and combining similar values in sql
SQL
0 vote181 views1 answer
ORA-01400
SQL
0 vote118 views1 answer
10000000000000000000 am to meters
SQL
4 votes130 views4 answers
Pl sql output
SQL
0 vote179 views1 answer
Sql ssrs
SQL