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 vote356 views1 answer
Oracle create index if not exists
SQL
0 vote364 views1 answer
Mysql update table from select on another table
SQL
0 vote364 views4 answers
Mysql count table rows
SQL
0 vote361 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
5 votes373 views1 answer
Dbms_metadata.get_ddl table
SQL
1 vote385 views1 answer
Customer using hdfc bank sql query
SQL
0 vote352 views1 answer
Use where instead of join
SQL
0 vote351 views1 answer
Sql offfset
SQL
0 vote370 views1 answer
Double in sql server example
SQL
10 votes366 views1 answer
User_dependencies
SQL