Weird Query

Hi,

Behold the following SQL-Plus-Session, run against an Oracle 9i (Patch 2) Server:

> SQL> select pp_lock from cbr_385120060b39d42d8;
>
> PP_LOCK
> ----------------------------------------------------------------------------
> STEFANWIMMER\goit consulting\658.1_at_STEFANWIMMER
>
>
> SQL> select pp_lock from cbr_385120060b39d42d8 where pp_lock = '';
>
> Es wurden keine Zeilen ausgewählt
>
> SQL> select pp_lock from cbr_385120060b39d42d8 where pp_lock <> '';
>
> Es wurden keine Zeilen ausgewählt
>
> SQL> select pp_lock from cbr_385120060b39d42d8 where pp_lock is null;
>
> Es wurden keine Zeilen ausgewählt

So the table _does_ have exactly one record. Which is not returned in any of the queries that select specific values of PP_LOCK.

I am not an Oracle-Expert by far, but this still puzzles me. Any explanations?

Ciao, MM

-- 
Marian Aldenhövel, Rosenhain 23, 53123 Bonn. +49 228 624013.
http://www.marian-aldenhoevel.de
"It's easy to make a small fortune in aviation,
  provided you start with a big one"