Re: Problem in SELECT ... WHERE ... IN

You might try reworking your statements by using Chr(39) instead of ' (single quote). Your PL/SQL could use dynamic SQL or static SQL that you dynamically select.

If Var2 Is Null Then

    Some statement with just Var1
Else

    Some statement with Var1 & Var2
End If
...

Mike Rose

lamtse wrote in message <7cfpr0$l1$1_at_imsp009a.netvigator.com>...
>Dear Oracle experts,
>
> I have the following problem: The following SQL is okay:
>
>insert into table_1
>select column_1 from table_2
>where column_2 IN ('KG' and 'GD');
>
Received on Tue Mar 16 1999 - 09:50:32 CST