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
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;


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: 65133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
NULL is empty string.

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

Current Time: Wed Aug 16 10:24:12 CDT 2017

Total time taken to generate the page: 0.16533 seconds