Re: empty string, NULL, NOT NULL

From: <alistair.thomson_at_sphinxcst.co.uk>
Date: Thu, 06 Jan 2000 16:41:50 GMT
Message-ID: <852gka$1pl$1@nnrp1.deja.com>

Try this in your select statement

select * from my_table
where column1 is null;

Hope this helps

Alistair Thomson

In article <852e39$vmr$1_at_nnrp1.deja.com>, x3x3_at_my-deja.com wrote:
> Hello,
>
> could you tell me for a field what these things would mean viz.
> if I say a colume as allows NULL and then if its varchar2,
> could I use in where clause empty string?
> where col = ''
> I tried it and it was not matching it. so could one explain me if
> '' and NULL are same or is '' a valid empty string.
>
> Then when I say the col as NOT NULL can I insert '' into it for
> varchar2.
>
> I guess If am clear with my doubt would you email me at:
>
> mehta_at_mama.indstate.edu
>
> Thanks.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jan 06 2000 - 10:41:50 CST