Home » SQL & PL/SQL » SQL & PL/SQL » varying elements in IN list
varying elements in IN list [message #37958] Fri, 08 March 2002 11:36 Go to next message
Neelam
Messages: 3
Registered: March 2002
Junior Member
Hi,

I'm writing a function in which i'm passing an argument.Based on the value of this argument, i have to create a list of values of store it in a variable.
Then I need to use this variable in my select statement with IN operator.

Suppose based on my argument i have the values 'a','b','c'. I want to store these values in a variable and then want to pass it to my Select Statement.

So I want to use in my select statement as
Select * from trial where col1 in (variable);

How can i do it in a proper way. Please let me know. Its quite urgent.
Thanks in advance.

Neelam
Re: varying elements in IN list [message #37959 is a reply to message #37958] Fri, 08 March 2002 12:42 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
<url>http://asktom.oracle.com/pls/ask/f?p=4950:8:128721::NO::F4950_P8_DISPLAYID</url>
Previous Topic: PL/SQL Function
Next Topic: null
Goto Forum:
  


Current Time: Tue Oct 19 20:25:08 CDT 2021