OraFAQ Forum: SQL & PL/SQL » what is the difference between '' and ' '

Home » SQL & PL/SQL » SQL & PL/SQL » what is the difference between '' and ' '

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

what is the difference between '' and ' ' [message #18593]

Thu, 07 February 2002 01:15

ksr
Messages: 112
Registered: January 2002

Senior Member

Hi,
What is the differnce between ''(quotes without space between them)

and

' ' (quotes with spaces between them.

I have issued the query like
select * from tab1 where col1 <> '' --does not return values

select * from tab1 where col1 <> ' ' --returns values

Any explanation on this

Report message to a moderator

Re: what is the difference between '' and ' ' [message #18597 is a reply to message #18593]

Thu, 07 February 2002 03:48

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

'' equal to null or empty
but u have to query like this:

select * from tab1 where col1 is not null

2) space is also character. i think data stored in this column is single space not null.

Report message to a moderator

Previous Topic:	INSERT using BIG subquery
Next Topic:	SQL*PLUS error messages - online?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 16 10:23:22 CDT 2026