Home » SQL & PL/SQL » SQL & PL/SQL » what is the difference between '' and ' '
what is the difference between '' and ' ' [message #18593] Thu, 07 February 2002 01:15 Go to next message
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
Re: what is the difference between '' and ' ' [message #18597 is a reply to message #18593] Thu, 07 February 2002 03:48 Go to previous message
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.
Previous Topic: INSERT using BIG subquery
Next Topic: SQL*PLUS error messages - online?
Goto Forum:
  


Current Time: Sun Sep 19 12:46:00 CDT 2021