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

1 vote166 views1 answer
Opensuse restart MySQL
SQL
0 vote183 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
2 votes149 views3 answers
Mysql pass command from command line
SQL
3 votes144 views1 answer
Postgres count distinct
SQL
0 vote189 views1 answer
CONVERT time string into 12 hours in sql
SQL
2 votes90 views1 answer
Sql select in list
SQL
-1 vote199 views3 answers
MAKE TABLE FIT in oracle sql
SQL
1 vote214 views1 answer
Oracle datafile max size 32gb
SQL
0 vote154 views1 answer
Sql statement show all emails with dome
SQL
1 vote143 views1 answer
Access the postgres psql
SQL