Yes. Snippet of code follows:


select cols bulk collect into array


forall i in array.first..array.last
update a_table
set approved = 'Y'
where account_no = array(i)



regards,

john f. lewis



-----Original Message-----
Regis,

Is it possible to perform an UPDATE on a "index by table collection" as
below:?





**********************************************************
DISCLAIMER: This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to whom they are
addressed. If you have received this email in error please notify the sender
by replying to this message and then delete it from your system. Use,
dissemination or copying of this message by unintended recipients is not
authorized and may be unlawful. Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of the company. Finally, the recipient should
check this email and any attachments for the presence of viruses. The
company accepts no liability for any damage caused by any virus transmitted
by this email.





Oracle LazyDBA home page