Get primary key of table

SELECT a.COLUMN_NAME
FROM all_cons_columns a INNER JOIN all_constraints c 
     ON a.constraint_name = c.constraint_name 
WHERE c.table_name = 'TBL'
  AND c.constraint_type = 'P';

Similar codes

1 vote319 views1 answer
Reutrn string after character sql
SQL
0 vote371 views1 answer
Set Mamp mysql globally
SQL
0 vote439 views1 answer
How to check foreign key constraint in sql
SQL
15 votes347 views6 answers
Psql
SQL
1 vote373 views1 answer
Oracle nvl2
SQL
0 vote325 views2 answers
Sql update from two different database
SQL
8 votes376 views1 answer
Oracle search text in all packages
SQL
0 vote358 views1 answer
Uninstall mysql ubuntu 18.04 stackoverflow
SQL
1 vote341 views1 answer
Scaffold mysql database
SQL
6 votes352 views2 answers
Oracle
SQL