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

0 vote169 views2 answers
Android sqlite query join
SQL
0 vote151 views0 answer
SQL
0 vote193 views1 answer
Mysql max number not returning correct value
SQL
6 votes178 views5 answers
Get current date sql
SQL
4 votes205 views1 answer
Sql quote in string
SQL
0 vote203 views1 answer
Mysql select where field is a value
SQL
0 vote195 views1 answer
Reona
SQL
0 vote188 views1 answer
Utiliser sql ligne de commande
SQL
1 vote212 views1 answer
Mysql update inner
SQL
0 vote171 views1 answer
Materialized view redshift
SQL