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 vote175 views1 answer
TSQL Find csv file in folder
SQL
1 vote106 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
0 vote116 views1 answer
Can we rollback deleted data in sql
SQL
0 vote116 views1 answer
With_for_update sqlalchemy
SQL
0 vote123 views1 answer
How to create a new shema using query languaage
SQL
17 votes110 views4 answers
Show tables sql server
SQL
10 votes124 views2 answers
Mysql drop database if exists
SQL
1 vote115 views1 answer
Oracle start job
SQL
0 vote77 views1 answer
Postgresql subquery
SQL
1 vote128 views1 answer
Oracle stop
SQL