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 vote126 views1 answer
Sql drop default
SQL
1 vote136 views1 answer
Add multiple row table pl sql
SQL
1 vote146 views1 answer
Mysql dump specific tables
SQL
0 vote131 views1 answer
Joins vs includes
SQL
0 vote123 views1 answer
Pl/sql loop example
SQL
3 votes115 views1 answer
Oracle failed login attempts
SQL
6 votes119 views5 answers
Alter table oracle
SQL
1 vote127 views1 answer
Mysql count multiple columns in one query
SQL
0 vote131 views1 answer
Resullt all update knex mysql
SQL
0 vote130 views1 answer
Systemverilog unique constraint unique values
SQL