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
cmouli_84
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: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is there any way to accomplish this?

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

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


Current Time: Wed Dec 07 18:35:50 CST 2016

Total time taken to generate the page: 0.18739 seconds