Variable formatting [message #305192] |
Mon, 10 March 2008 01:47 |
ora_2007
Messages: 430 Registered: July 2007 Location: Mumbai
|
Senior Member |
|
|
Hi,
I need help rearding manipulation of variable.
Variable may be in any form:
v_test := 'ADD,MUL,SUB';
or
v_test := 'ADD,MUL,';
or
v_test := ',MUL,SUB';
or
v_test := 'ADD,MUL,SUB';
or
v_test := ', ,SUB';
or
v_test := 'ADD, ,SUB';
or
v_test := 'ADD,,';
then my query will be...
select id
into v_id
from test_tab
where oper in (v_test)
How could i format my variable so that I will not get any error?
Thanks in advance.
|
|
|
|
|