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 vote355 views1 answer
Oracle drop temporary table
SQL
0 vote286 views1 answer
Alter session set nls_language french
SQL
1 vote330 views2 answers
Mysql extract number from string
SQL
0 vote326 views1 answer
Stored procedures example
SQL
0 vote299 views1 answer
Get week day name sql server
SQL
0 vote312 views1 answer
Psql attribute cannot login
SQL
0 vote309 views1 answer
Oracle activate program
SQL
0 vote287 views1 answer
Mysql update sum same table
SQL
0 vote336 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
0 vote261 views1 answer
Sql select rows with simlar names
SQL