Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: simple oracle SQL question
Try this
SELECT * FROM tktmaster WHERE closedate IS NULL;
should work
Jim Belcher
Systems Analyst
First Union National Bank
On Mon, 07 Dec 1998 10:09:27 -0500, Brad McBride <Brad.McBride_at_Axom.com> wrote:
>I hope that I am sending this to the correct place and my sincere
>apologies if I am going off of the topic. I am working on a very simple
>oracle SQL query and have been seperated from my SQL guide books (they
>are 200 miles from my present location). I have a table that stores
>information about services that are being performed. These services,
>when created, have a SYSDATE placed in a field called "opendate" and a
>NULL value placed in the field called "closedate". I am now wanting to
>retrieve a list of all services that are still open, i.e., have no
>closedate. I tried the following two commands to no avail:
>
>SELECT * FROM tktmaster WHERE closedate='NULL';
>
>and
>
>SELECT * FROM tktmaster WHERE closedate=' ';
>
>There is probably something very simple that I have forgotten but
>without my SQL reference, I'm lost. Thanks for any assistance that
>anyone may be able to provide.
>
>Brad McBride
Received on Tue Dec 15 1998 - 21:08:29 CST