Home » RDBMS Server » Server Administration » Using parameter variables in a "IN" statement
Using parameter variables in a "IN" statement [message #374300] Tue, 05 June 2001 04:22
TimA
Messages: 2
Registered: June 2001
Junior Member
I'm trying to use parameter variable in an "IN" statement as follows :

v_range := var_1||','||var_2||','||var_3

select * from my_table
where code_field in (v_range)

But this doesn't seem to work. Any ideas how I can do this ???

Report message to a moderator

Previous Topic: Using parameter variables in a "IN" statement
Next Topic: Need Help with Simple SQL query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 13:43:11 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.