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: 64954
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: Mon Jun 26 02:17:42 CDT 2017

Total time taken to generate the page: 0.04098 seconds