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 votes337 views1 answer
Tsql copy table
SQL
0 vote322 views1 answer
How to query all tables mysql at the same time
SQL
20 votes346 views3 answers
How to open postgresql in mac
SQL
0 vote317 views1 answer
Sql remove first character from string
SQL
1 vote374 views1 answer
Oracle plan hash value
SQL
0 vote351 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote322 views1 answer
Create a PostgreSQL user django on mac
SQL
0 vote275 views1 answer
Postgresql add leading zeros
SQL
2 votes318 views1 answer
Oracle table size
SQL
1 vote341 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL