Home » SQL & PL/SQL » SQL & PL/SQL » Dynamic where condition
Dynamic where condition [message #344277] Fri, 29 August 2008 05:23 Go to next message
soni_7
Messages: 33
Registered: July 2005
Member
Hi,

I have to pass a comma separated string as a IN parameter to a procedure. The string is basically a list of numbers with comma separated.
This string would be used in the IN clause of where condition against a column of NUMBER data-type, inside the procedure. I know i cannot just place the variable inside IN clause bracket.
Searched, but couldn't find any solution.
Is it that i have to use a substr and proceed?

Thanks in advance.

Regards
Soni
Re: Dynamic where condition [message #344286 is a reply to message #344277] Fri, 29 August 2008 05:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search again, it has been asked and answered many and many times.
Keyword: varying inlist.

Regards
Michel
Re: Dynamic where condition [message #344288 is a reply to message #344286] Fri, 29 August 2008 05:45 Go to previous message
soni_7
Messages: 33
Registered: July 2005
Member
Thanks a lot.
Many options to go through, i will check them.
Thanks You
Previous Topic: Thinking of using Merge Statement
Next Topic: date display
Goto Forum:
  


Current Time: Thu Dec 08 00:16:10 CST 2016

Total time taken to generate the page: 0.05929 seconds