Checking a functional index on a table and its metadata
742866Nov 22 2010 — edited Nov 22 2010Hi,
I have a functional based normal index (unique) defined on a table which uses a decode function and a combination of the columns of a table.
Eg : decode (status, 'A', column1 || column 2, column1 || column2 || column3)
Now my question is, how do we query these functional indexes from the database to see what exactly the function is...
On the database when I run a query :-
select from all_indexes where index_name = :index_name,*
it retrieves the code name of the index stored as ncs$00025 (don't remember the exact value).
How do I find out what exactly the function is? (from which table)
and is there any way that I can query the data that has been indexed by this unique index so that I can verify why the unique constraint is being violated in some cases?
Thanks and Regards,
Suyash