Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Checking for empty date fields

Re: Checking for empty date fields

From: David Turner <turner_at_tellme.com>
Date: Thu, 14 Sep 2000 09:37:46 -0700
Message-Id: <10619.116981@fatcity.com>


where last_analyzed is null;
On Thu, Sep 14, 2000 at 12:21:18AM -0800, Andreas Jung wrote:
> 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=null" nor
> "where to_char(last_analyzed)=''" did work. Any idea ?
>
> Thanks,
> Andreas
> --
> 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 - 11:37:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US