sam15
asked on
lookupIndexColumnns
I have an index on a table with a name IDX_UNIQUE_T1 and column name is SYS_NC00072$
I am trying to figure out the columns for this inde from user_ind_columns but can't tell what it is.
any ideas how>
I am trying to figure out the columns for this inde from user_ind_columns but can't tell what it is.
any ideas how>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
the first statement gives me the same column name "SYS_NC00072$" for column name.
the second SQL did not work. I think 9202 has issues or a bug with this the DBMS_METADATA or it is not supported.
I found the DDL using TOAD and the index is function based index.
CASE WHEN BKNO > 20000 THEN MEDIUM||','||TO_CHAR(BKNO) ELSE NULL END
not sure why the FBI does not show a valid column name. I think thsi index is enforcing a uniqe values on the combination of the two columns for numbers larger than 20000.
the second SQL did not work. I think 9202 has issues or a bug with this the DBMS_METADATA or it is not supported.
I found the DDL using TOAD and the index is function based index.
CASE WHEN BKNO > 20000 THEN MEDIUM||','||TO_CHAR(BKNO)
not sure why the FBI does not show a valid column name. I think thsi index is enforcing a uniqe values on the combination of the two columns for numbers larger than 20000.
select column_name from user_ind_columns where index_name='IDX_UNIQUE_T1'