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 vote110 views1 answer
Exec procedure oracle
SQL
0 vote119 views1 answer
Get who is hired in february in sql
SQL
0 vote106 views1 answer
Sql server udf performance
SQL
0 vote112 views1 answer
Order by in codeigniter query builder
SQL
0 vote102 views2 answers
Sql drop view if exists
SQL
1 vote115 views1 answer
Nullif postgresql
SQL
0 vote75 views1 answer
Mysql offset from bottom
SQL
0 vote114 views1 answer
Wordpress sql change site url
SQL
1 vote119 views1 answer
Oracle previous year
SQL
1 vote168 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL