Skip to Main Content
Forums

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!

Efficient way of parsing through a tab type in PL/SQL

814928Nov 16 2010 — edited Nov 16 2010
Hi All,

I have a tab type which has a list of values(say numbers) in a PL/SQL block. I need to check how many of those values are greater than 1000.
How do I parse through the tab type in an efficient way to find the count?
Should I open the tab type in a loop or should I fetch the tab type into a cursor and open it?
Or is there any other efficient way of doing this?

Thanks in advance for the help.

Rgds,
Janaki
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 14 2010
Added on Nov 16 2010
2 comments
1,009 views