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 vote169 views1 answer
View to table sql
SQL
0 vote150 views1 answer
Sql column as header
SQL
0 vote132 views1 answer
Sql examples from your work
SQL
10 votes148 views1 answer
Oracle view dependencies
SQL
0 vote150 views1 answer
How to to get current date in sql
SQL
0 vote164 views1 answer
PGSQL dynamic table name
SQL
0 vote144 views4 answers
Mysql count table rows
SQL
4 votes208 views1 answer
Postgresql list sequences
SQL
0 vote161 views1 answer
Take sql dump in to file
SQL
0 vote164 views1 answer
Can you write relational algebra into sql queries
SQL