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

7 votes119 views2 answers
Where keyword sql
SQL
0 vote103 views1 answer
Oracle exchange subpartition
SQL
0 vote101 views1 answer
Alter table myisam to innodb
SQL
0 vote91 views1 answer
Select value from previous row in postgresql
SQL
7 votes105 views1 answer
Safe update mysql
SQL
10 votes106 views5 answers
Between keyword in sql
SQL
0 vote128 views1 answer
Sqlite trim
SQL
2 votes103 views1 answer
Columns Present in a table
SQL
0 vote112 views1 answer
Sql datediff month
SQL
3 votes107 views3 answers
Your password does not satisfy the current policy requirements
SQL