How to get primary key column in Oracle?

by 
SELECT cols.table_name, cols.column_name, cols.position, cons.status, cons.owner
FROM all_constraints cons, all_cons_columns cols
WHERE cols.table_name="TABLE_NAME"
AND cons.constraint_type="P"
AND cons.constraint_name = cols.constraint_name
AND cons.owner = cols.owner
ORDER BY cols.table_name, cols.position;

Make sure that ‘TABLE_NAME’ is in upper case since Oracle stores table names in upper case.

More Related Contents:

  1. ANYONE CAN TELL ME THAT WHY THIS CODE IS GIVING ME AN ERROR OF TABLE OT CLUSTER KEY WORD IS MISSING? [closed]
  2. How to describe performance issue in relational database?
  3. How do I escape a reserved word in Oracle?
  4. How to put more than 1000 values into an Oracle IN clause [duplicate]
  5. ORA-30926: unable to get a stable set of rows in the source tables
  6. ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
  7. Fetch Oracle table type from stored procedure using JDBC
  8. “Safe” TO_NUMBER()
  9. When or Why to use a “SET DEFINE OFF” in Oracle Database
  10. error: ORA-65096: invalid common user or role name in oracle
  11. Oracle insert if not exists statement
  12. Error : ORA-01704: string literal too long
  13. Oracle client ORA-12541: TNS:no listener [closed]
  14. Create an Excel Spreadsheet from a Oracle Database
  15. How do I turn off Oracle password expiration?
  16. Faster alternative in Oracle to SELECT COUNT(*) FROM sometable
  17. Oracle date difference to get number of years
  18. SQL Fiddle Output Error
  19. oracle PL/SQL how to calculate range ip for IPv6 cidr
  20. How to find out when an Oracle table was updated the last time
  21. NLS_LANG setting for JDBC thin driver?
  22. Trying to export a Oracle via PL/SQL gives a date of 0000-00-00
  23. Oracle: how to add minutes to a timestamp?
  24. How to drop multiple interval partitions based on date?
  25. How to list active / open connections in Oracle?
  26. ORA-01830: date format picture ends before converting entire input string / Select sum where date query
  27. How to convert “1985-02-07T00:00:00.000Z” (ISO8601) to a date value in Oracle?
  28. How to generate a version 4 (random) UUID on Oracle?
  29. Oracle SQL Developer: Show REFCURSOR Results in Grid?
  30. Find out the history of SQL queries

Leave a Comment