OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » no value

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

no value [message #1700]

Thu, 23 May 2002 13:03

lerone streeter
Messages: 2
Registered: May 2002

Junior Member

i'm trying to do a select, the colums in my where clause are a date and numeric. i want to see all records where no value is entered in the date or numeric field. i've tried coverting them using to_char and comparing against ' ' but it doesn't return results. if i say <> ' ' i get results. what must i use to represent blank?

select f1, f2, f3 from table where f9=' ' and f10=' ';

select f1, f2, f3 from table where to_char(f9)=' ' and to_char(f10)=' ';

Report message to a moderator

Re: no value [message #1701 is a reply to message #1700]

Thu, 23 May 2002 13:08

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

use NULL.
**********************************

1 select * from emp where comm is null
2* and mgr is null
SQL> /

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- ----------
7839 KING PRESIDENT 23-MAY-02 5000 10

Report message to a moderator