Home » SQL & PL/SQL » SQL & PL/SQL » null concept (oracle 9i)
null concept [message #399190] Tue, 21 April 2009 01:33 Go to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
SQL>select null from dual;
It returns null value

If we perform
SQL>select 'ram'||null||'esh' name from dual;

NAME
----------
ramesh

Why it's not returning null ,what is the reason.
Re: null concept [message #399204 is a reply to message #399190] Tue, 21 April 2009 02:08 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
NULL is empty string.

Regards
Michel
Previous Topic: Statistics details
Next Topic: Differnece between Varchar2 and CHAR
Goto Forum:
  


Current Time: Sun Dec 04 02:51:46 CST 2016

Total time taken to generate the page: 0.08482 seconds