Re: SQL Help

Use IF a_variable is null.... instead.

Thanks,

Vrajesh Patel.

Paul Davies wrote:

> When I have a select statement:
>
> select COL_A into a_variable from TABLE where TABLE.COL_B = value
>
> IF a_variable = null....
>
> within a PLSQL procedure, the procedure bombs out if no values are found.
> In Sybase, however, a_variable would be set to null. Is there a simple way
> I can force the select to behave like this in Oracle - ie it continues if no
> values are found and sets a_variable to null?
>
> Help appreciated
>
> Paul
Received on Fri Apr 23 1999 - 14:26:26 CDT