Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Query returns wrong results
Hi,
I have a table with a number(15,4) column.
If I query that table as follows:
select * from mytable where number_column > 0
If get the rows containing the 0 value !!!!!! I should not. When I look in sqlplus the number is really 0, the only way it does not display is when I do a select with greater then 1.
I don't get it. does anyone know what's going on??
I'm using oracle 8.1.7.0 on solaris 7
Thanks in advance,
Steve.
--
http://www.sonnenkoepfl.de http://unterkunft-berchtesgaden.de http://pension-berchtesgaden.deReceived on Thu Jan 23 2003 - 03:23:49 CST