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 vote335 views1 answer
Mysql show queries running
SQL
0 vote319 views1 answer
Dapper run sql script with parameters
SQL
0 vote345 views1 answer
Sql server Cost Fifo query
SQL
18 votes332 views4 answers
Mysql current date between two dates
SQL
1 vote323 views1 answer
Rermove categories woocommerce sql
SQL
0 vote377 views1 answer
Mysql insert multiple rows based on select
SQL
0 vote352 views1 answer
Neo4j command to run script file
SQL
1 vote341 views1 answer
Sql server list locks
SQL
0 vote350 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
0 vote321 views1 answer
How to get employee having maximum experience in mysql
SQL