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.

Report message to a moderator

Re: null concept [message #399204 is a reply to message #399190] Tue, 21 April 2009 02:08 Go to previous message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
NULL is empty string.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Feb 06 14:16:26 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.