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

5 votes145 views1 answer
Oracle sysdate - 1 month
SQL
13 votes153 views3 answers
Sql select from multiple tables without join
SQL
0 vote147 views1 answer
Month mysql
SQL
0 vote135 views1 answer
Oracle exchange partition
SQL
1 vote258 views3 answers
Create table from existing table in sql
SQL
49 votes203 views6 answers
Get duplicate records in sql
SQL
6 votes118 views4 answers
Mysql update set
SQL
0 vote125 views1 answer
Postgresql update to unique
SQL
2 votes132 views1 answer
Datetrunc
SQL
1 vote145 views1 answer
How to see all table partition in oracle
SQL