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

2 votes187 views1 answer
Compare date in sql
SQL
1 vote188 views1 answer
Spark sql concatenate string and int
SQL
1 vote152 views1 answer
Mysql show attributes of a table
SQL
0 vote183 views1 answer
Différence entre deux dates sql oracle
SQL
1 vote184 views3 answers
How to get date in sql
SQL
4 votes195 views1 answer
Sql data types
SQL
5 votes186 views1 answer
Oracle sysdate
SQL
5 votes186 views1 answer
Oracle nls session
SQL
0 vote204 views1 answer
Except in sql
SQL
0 vote203 views1 answer
How to access to mysql without root
SQL