Tuesday, August 22, 2017

Query to find Indexed Column names in table

SELECT c.index_name, i.uniqueness, c.column_name
FROM   user_indexes i, user_ind_columns c
WHERE  i.index_name = c.index_name
  AND  i.table_name = UPPER(:P_TABLE_NAME)
ORDER  BY c.index_name, c.column_position;

1 comment:

  1. [YouTube] Visions Of Batman And Robin (1991 - Videodl.cc
    [YouTube] Visions Of Batman And Robin (1991] - Videodl.cc. Watch best youtube to mp3 videos related to Batman And Robin (1991) on Vimeo.