Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.tools -> '' IS NULL?

'' IS NULL?

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Sun, 10 Dec 2000 16:37:08 GMT
Message-ID: <3a33b0ec.1699254234@news.alt.net>

SELECT NVL('', 'Moo?') FROM Dual;

NVL(

Moo?

Why is a blank string considered Null?

Brian Received on Sun Dec 10 2000 - 10:37:08 CST

This message: [ Message body ]
Next message: Kevin McDaniel: "Re: '' IS NULL?"
Previous message: kiran: "Oracle - Developer 2000 error message no OG - 01603"
Next in thread: Kevin McDaniel: "Re: '' IS NULL?"
Reply: Kevin McDaniel: "Re: '' IS NULL?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US