Is it possible to do this query with a loop in oracle?

Question

Is it possible to do this query with a loop, or a list, to get the results for several indexes? Thank you.

select ctx_report.create_index_script('LISTOFINDEXES') from dual;

Alex Poole · Accepted Answer · 2022-10-05 14:42:02Z

1

You could pass a list of index names with a collection:

select ctx_report.create_index_script(column_value)
from table(sys.odcivarchar2list('INDEX_1', 'INDEX_2'));

Or you could base it on the data dictionary:

select ctx_report.create_index_script(index_name)
from user_indexes
where ...

or perhaps more usefully:

select ctx_report.create_index_script(idx_name)
from ctx_user_indexes;

answered Oct 5, 2022 at 14:42

Alex Poole

192k11 gold badges198 silver badges349 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1