Check for index existing.
I'm a DBA working with 3 application developers, they want to know how to check for index existing for certain column
in a table in their schema,
one friend told me , to check for index existing for certain column you have to query
the view dba_ind_columns so you have to be a sysdba user
but I don't want to grant the application developers the sysdba privilage
but my friend told me , to avoid grant sysdba to the application developers, they can query the view user_indexes in their schema, but after watching the view user_indexes ,
it gives me a lot of data but doesn't give me the COLUMN NAME
0