Re: Checking for empty date fields

                                                                                                                   
                    Andreas Jung                                                                                   
                    <ajung_at_sz-sb.        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>       
                    de>                  cc:                                                                       
                    Sent by:             Subject:     Checking for empty date fields                               
                    root_at_fatcity.                                                                                  
                    com                                                                                            
                                                                                                                   
                                                                                                                   
                    09/14/2000                                                                                     
                    01:21 PM                                                                                       
                    Please                                                                                         
                    respond to                                                                                     
                    ORACLE-L                                                                                       
                                                                                                                   
                                                                                                                   

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"

Try
where last_analyzed is Null
HTH
Azhar
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).