Re: PL/SQL: handling of empty string (strange)

From: Tony <andrewst_at_onetel.net.uk>
Date: 15 Mar 2004 05:10:19 -0800
Message-ID: <c0e3f26e.0403150510.72877eba@posting.google.com>

"Michel Cadot" <micadot{at}altern{dot}org> wrote in message news:<405080ee$0$304$636a15ce_at_news.free.fr>...
> As we said it here many and many times '' is NULL, so
> 'S' != '' is equivalent to 'S' != NULL which is NEVER true.

Yes, but remember that that is an Oracle idiosyncrasy, not the way standard SQL works. That’s why it catches so many people out. Received on Mon Mar 15 2004 - 07:10:19 CST

This message: [ Message body ]
Next message: Noons: "Re: How to invoke export/import or sql loader?"
Previous message: alederer: "How to invoke export/import or sql loader?"
In reply to: Michel Cadot: "Re: PL/SQL: handling of empty string (strange)"
Next in thread: Andy Hassall: "Re: PL/SQL: handling of empty string (strange)"

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