<> '' in PL/SQL

From: Norris <johnnie_at_cooper.com.hk>
Date: 14 Sep 1999 10:43:18 GMT
Message-ID: <7rl8s6$4qs$1@adenine.netfront.net>

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 - 05:43:18 CDT