Newbie Question: Array in PL/SQL SP
559589Apr 18 2007 — edited Apr 19 2007Hi Oracle Gurus,
This is what I need to accomplish in algorithm and just wondring how to do it in PL/SQL Stored Procedure:
name_array = { 'ABC*', 'CDE*', 'EFG*'...... }
i = 1
FOR EACH MEMBER OF ARRAY name_array
SQL = 'SELECT * FROM ALL_TABLES WHERE table_name like ''' || name_array[i] || ''';
i := i+1;
END FOR;
Your inputs are really appreciated.
ALEX