Re: <> '' in PL/SQL

Hy Norris

Try putting a space between the ''.
Instead of :

    if abc <> '' then
Use:

    if abc <> ' ' then

Hope this helps

Ciao Gennaro

Norris wrote:

> I am writing some simple PL/SQL , but I cannot intepret the result:
>
> set serveroutput on
> declare
> abc varchar2(1);
> begin
> abc := 'a';
> if abc <> '' then
> dbms_output.put_line(abc||' <> empty');
> else
> dbms_output.put_line(abc||' = empty');
> end if;
> end;
>
> The Result
> ----------
> ServerOutput ON
> Statement processed.
> a = empty
>
> --
> - Have several nice days...
> - Opinions are mine and do not necessarily reflect those of the Corp.
> http://www.ntfaq.com
> http://www.cyberport.com/~tangent/programming/winsock/
Received on Tue Sep 14 1999 - 07:46:10 CDT