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 vote187 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
0 vote186 views1 answer
Use between operator in mysql
SQL
0 vote191 views1 answer
What is between operator
SQL
0 vote190 views1 answer
Export partttion and import in oracle
SQL
0 vote210 views1 answer
Mysql where sum > 0
SQL
0 vote191 views1 answer
Sql select first and last record of each group
SQL
1 vote210 views1 answer
SQL Integer devision
SQL
0 vote195 views1 answer
Postgresql import a database of gzip
SQL
1 vote185 views1 answer
List index mysql cli
SQL
0 vote214 views1 answer
Mysql 5.7 in centos 7
SQL