Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

using select statement to put in values to an array.

ankitbarsainyaOct 22 2012 — edited Oct 22 2012
Hi,
I need to use a select statement to store values inside a array. below is the statement to be used
select column_name into array from all_tab_columns;

Once the values are loaded in the array i need to traverse through this array and check for possible matches based on which i can create a procedure around it.
Regards,
Ankit
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 19 2012
Added on Oct 22 2012
7 comments
8,239 views