Home » RDBMS Server » Server Administration » Using parameter variables in a "IN" statement
Using parameter variables in a "IN" statement [message #374299] Tue, 05 June 2001 04:17
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: Re: DATE type and milliseconds
Next Topic: Using parameter variables in a "IN" statement
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 12:04:18 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.