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!

Array in Where Clause

551174Jun 16 2009 — edited Jun 18 2009
Hi,
I am having a function with an IN paramter as an array.
How do i use all the values in this array in the Where clause?

Function ( tArrayOfNos IN tArrType )
{
....

open Tstcursor FOR
select ...
from ...
where tNo in <all the nos in the array tArrayOfNos >

---

}

thanks for your help..
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 16 2009
Added on Jun 16 2009
9 comments
5,971 views