當前位置:編程學習大全網 - 網站源碼 - oracle主鍵查詢語句

oracle主鍵查詢語句

select table_name,constraint_name,

max(decode(position,1 ,column_name)),

max(decode(position,2 ,column_name)),

max(decode(position,3 ,column_name)),

max(decode(position,4 ,column_name)),

max(decode(position,5 ,column_name)),

max(decode(position,6 ,column_name)),

max(decode(position,7 ,column_name)),

max(decode(position,8 ,column_name)),

max(decode(position,9 ,column_name)),

max(decode(position,10,column_name)),

max(decode(position,11,column_name)),

max(decode(position,12,column_name)),

max(decode(position,13,column_name)),

max(decode(position,14,column_name)),

max(decode(position,15,column_name)),

max(decode(position,16,column_name))

from user_constraints uc,user_cons_columns ucc

where uc.constraint_name=ucc.constraint_name

and ucc.constraint_type='P'

group by table_name,constraint_name

  • 上一篇:棋牌源代碼商業化
  • 下一篇:引流腳本軟件?引流腳本就只是輔助的作用?
  • copyright 2024編程學習大全網