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 vote287 views1 answer
How to get parent and child record in single query using sql
SQL
0 vote313 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
0 vote284 views1 answer
Mysql locate
SQL
3 votes278 views2 answers
How to start mysql in terminal
SQL
0 vote284 views2 answers
Oracle select
SQL
0 vote285 views1 answer
Test sql query
SQL
0 vote275 views1 answer
Drop all tables db2
SQL
0 vote281 views1 answer
Create schema sql server
SQL
0 vote288 views1 answer
Set root password mysql xampp
SQL
0 vote290 views1 answer
What is top n result in sql
SQL