Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: migrating from sql server 2000 to oracle 9i-r2

Re: migrating from sql server 2000 to oracle 9i-r2

From: <rogergorden_at_gmail.com>
Date: 10 Mar 2005 11:36:06 -0800
Message-ID: <1110483366.880826.214680@f14g2000cwb.googlegroups.com>


DA:

Not to start a flame war but you wrote:

7. NULL means NULL not an empty string

(Which is what I teach in my class) but in another post

Frank van Bortel wrote:
>> I concluded from this that empty string and null in Oracle are one and
>> the same (at least as far as PLSQL), which is very different that in

>> just about every other language.

> Right. As documented, as known, as being taught in Oracle Basic
> SQL, 2nd day, before lunch.

> Oh - and it's not just PL/SQL, but SQL, too.
> PEBKAC
> --
> Frank van Bortel

And your wrote:

In my class it is covered in the first 2nd hour of lecture.

So, am I not getting something or what?

AFAIK:
NULL != empty string

Perhaps I am mis-understanding the thread.

Roger Received on Thu Mar 10 2005 - 13:36:06 CST

Original text of this message

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