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

2 votes217 views4 answers
Mysql select into new table
SQL
0 vote181 views2 answers
Sql query for getting details by id
SQL
0 vote165 views1 answer
Check if record exists mysql
SQL
0 vote197 views1 answer
Get created time of database psql 8
SQL
2 votes298 views1 answer
Mysql create user with remote access
SQL
1 vote172 views1 answer
Mysql history command
SQL
0 vote166 views1 answer
Sql delete where x or y or z
SQL
0 vote165 views1 answer
Postgres week number
SQL
0 vote172 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
7 votes189 views1 answer
Return insert results in POSTGRESQL
SQL