Home » SQL & PL/SQL » SQL & PL/SQL » Using variable (Using a string variable with IN operator)
Using variable [message #356019] Wed, 29 October 2008 01:20 Go to next message
Messages: 1
Registered: October 2008
Location: Chennai
Junior Member
I need to create a oracle stored procedure which will get a string variable as input parameter. Variable contains values delimited by commas which should be used with IN operator of a query. How to use the variable with IN operator of a SQL query.

When i tried doing so, query is assuming the entire string as a single value. Is there any way to accomplish this?
Re: Using variable [message #356023 is a reply to message #356019] Wed, 29 October 2008 01:32 Go to previous message
Michel Cadot
Messages: 63923
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is there any way to accomplish this?

Just search for your question as it is asked almost each and every week.

Previous Topic: sql query problem
Next Topic: How to optimize this code?
Goto Forum:

Current Time: Tue Oct 25 18:01:42 CDT 2016

Total time taken to generate the page: 0.11800 seconds