JUST DO IT ~

查詢一個表的主鍵名稱

select  *
  from dba_constraints t
  where t.table_name =upper('dl_cjhb')
      and t.constraint_type='P'


查詢表的主鍵對應的字段列表


select  tt.column_name
  from dba_constraints t, dba_ind_columns tt
  where t.table_name =upper('dl_cjhb')
      and tt.table_name=t.table_name
      and t.constraint_type='P'
      and t.index_name = tt.index_name

dba_cons_columns



OWNER                          CONSTRAINT_NAME                CONSTRAINT_TYPE TABLE_NAME                     SEARCH_CONDITION                                                                 R_OWNER                        R_CONSTRAINT_NAME              DELETE_RULE STATUS   DEFERRABLE     DEFERRED  VALIDATED     GENERATED      BAD RELY LAST_CHANGE INDEX_OWNER                    INDEX_NAME                     INVALID VIEW_RELATED
------------------------------ ------------------------------ --------------- ------------------------------ -------------------------------------------------------------------------------- ------------------------------ ------------------------------ ----------- -------- -------------- --------- ------------- -------------- --- ---- ----------- ------------------------------ ------------------------------ ------- --------------