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 vote249 views1 answer
Example database query
SQL
9 votes217 views2 answers
Sql limit order by
SQL
7 votes220 views2 answers
N highest salary in sql
SQL
0 vote224 views1 answer
Mysql 1 hour ago
SQL
0 vote221 views1 answer
Trigger value from maltiple table to single table mysql
SQL
1 vote253 views1 answer
How to delay stored procedure execution in sql server
SQL
0 vote211 views1 answer
Zsh: command not found: mysql mamp
SQL
2 votes234 views2 answers
Mysql on duplicate key update get value from values
SQL
0 vote217 views1 answer
Mysql:5.6 syntax create table
SQL
36 votes225 views3 answers
Finding duplicate column values in table with sql
SQL