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

3 votes291 views1 answer
Difference sql vs mysql
SQL
0 vote312 views1 answer
Azure sql server check foreign key
SQL
0 vote330 views1 answer
Oracle tablespace autoextend
SQL
1 vote304 views1 answer
Oracle db create new schema
SQL
0 vote303 views1 answer
Sql select most frequent value in group
SQL
0 vote340 views1 answer
Drop tables from local database postgres pgadmin
SQL
5 votes337 views1 answer
Oracle add time to date
SQL
0 vote315 views1 answer
18446744073709551615 mariadb left join order by
SQL
7 votes299 views1 answer
Oracle set sequence value to max(id)
SQL
1 vote300 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL