Skip to Main Content

SQL & PL/SQL

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!

open the collection with condition.

oratechsOct 13 2013 — edited Oct 13 2013

Hi gurus,

how do i open a collection based on condition.

something like(assume i have a l_tab nested table with attributes)

{code}

   for i in l_tab.first.. l_tab.last loop

    {

    if l_tab.ind(i)='P' then

    --------

       l_tab(i).id='1';

    }

 

{code}

i do not want to loop through entire collection, instead i want loop through records with   ind='P'    and update the same collection.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 10 2013
Added on Oct 13 2013
8 comments
2,235 views