AW: Checking for empty date fields

From: Schoen Volker <v.schoen_at_inplan.de>
Date: Thu, 14 Sep 2000 09:55:21 +0200
Message-Id: <10619.116945@fatcity.com>

Hi Andreas,

try "where last_analyzed is null"

Regards

Volker Sch=F6n
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de

-----Urspr=FCngliche Nachricht-----
Von: Andreas Jung [mailto:ajung_at_sz-sb.de] Gesendet: Donnerstag, 14. September 2000 10:21 An: Multiple recipients of list ORACLE-L Betreff: Checking for empty date fields

A very stupid question:

I want to get all rows from user_indexes whose LAST_ANALYZED date = column
is empty (not analyzed yet). Neither "where last_analyzed=3Dnull" nor=20 "where to_char(last_analyzed)=3D''" did work. Any idea ?

Thanks,
 Andreas
--=20
Author: Andreas Jung
  INET: ajung_at_sz-sb.de

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Sep 14 2000 - 02:55:21 CDT