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: 64622
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: Thu Mar 30 00:03:24 CDT 2017

Total time taken to generate the page: 0.16159 seconds