Today, i will share the query which will give the column names along with table name on which index is created.Below is the Query for the same.
select a.index_name,a.table_name,b.column_name from
all_indexes a,
all_ind_columns b
where a.table_name=b.table_name
and a.index_name=b.index_name
and a.uniqueness=’UNIQUE’ and
a.table_name in <LLIST OF TABLE NAMES>
Query to give column names which are not null in the table.
select table_name,column_name
from all_tab_columns
where table_name like ‘%ABC%’
and NULLABLE=’N’
and owner=<SCHEMA_NAME>
order by table_name