Home » SQL & PL/SQL » SQL & PL/SQL » query regarding value
query regarding value [message #302606] Tue, 26 February 2008 05:55 Go to next message
rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india
Senior Member

Hi Experts,

I have a query regarding the value of '' i.e.

select length(null),length('') from dual;


it gives no value in the above query.

so it means '' = null
and

null = null;

can i come to know that there are 2 expressions to express null i.e.

'' and null.

So is it a bug in oracle or oracle treat null with 2 i.e.

'' and null

Thus If I am to convey my message then reply ASAP because i am in need urgently.........
Re: query regarding value [message #302607 is a reply to message #302606] Tue, 26 February 2008 05:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, not a bug.

Regards
Michel
Re: query regarding value [message #302609 is a reply to message #302607] Tue, 26 February 2008 06:01 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Here's an interesting thread for you.

MHE
Previous Topic: How to reduce the column length (alternative way) ?
Next Topic: get the second highest salary
Goto Forum:
  


Current Time: Sun Dec 04 04:20:33 CST 2016

Total time taken to generate the page: 0.10775 seconds