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

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

Checking for empty date fields

From: Andreas Jung <ajung_at_sz-sb.de>
Date: Thu, 14 Sep 2000 09:14:49 +0200
Message-Id: <10619.116942@fatcity.com> 





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
Received on Thu Sep 14 2000 - 02:14:49 CDT












Original text of this message













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