>Thanks Larry,
>
>>
If you know the back-end you are working with, you can branch two routes to get this information.>
>It worked fine for SQL Server, but I'm getting an empty cursor for Oracle, maybe because I don't have access (grant) to the user_indexes table?
>
Fernando,
If you didn't have access to the view (it's a view not a table), you would get a SQL error saying object didn't exist. It's possible there are no indexes for the given table or the WHERE clause doesn't have the correct criteria. Try using LIKE instead of = and see if there results are different.
select * from user_indexes where upper(table_name) like 'MYTABLE%'
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao