如何在oracle中查找表，视图和同义词的所有索引及其列

我记下了以下查询，该查询将列出特定表的索引名称及其列:

I jotted down the following query which will list the index name and its columns for a particular table:

select 
b.uniqueness, a.index_name, a.table_name, a.column_name 
from all_ind_columns a, all_indexes b
where a.index_name=b.index_name 
and a.table_name = upper('table_name')
order by a.table_name, a.index_name, a.column_position;

我想对此进行修改，以便如果我传入view或synonym也可以.我们的系统具有不同的视图，同义词，因此如果我可以为其提供名称(无论是视图同义词还是表)，它都会吐出索引及其列，这对查询非常有帮助.

I want to modify this so that if I pass in a view or synonym also it works. Our system has variations of views, synonyms so it will be really helpful to have one query to which i can just supply the name (be it view synonym or table) and it would spit out the indexes and their columns.