| Using variable [message #356019] |
Wed, 29 October 2008 01:20  |
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  |
 |
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
