Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: finding dates are not in table
A modified form of the following script might answer your question -
select to_date('01-jan-1996','dd-mon-yyyy') + rownum - 1
from any_table_with_more_than_366_records
where rownum < 367
minus
select distinct your_date_column from your_table
;
PEMM
Sandra Aguilar Velasco wrote in article <01bc96f6$a104d160$aa150fc8_at_saguila
.imta.mx>...
>I am trayin with sqlplus find all the dates are not in my table.
>
>How I can do it? ...
>besides create another table and put in this all the dates with out
blanks.
>
Received on Wed Jul 30 1997 - 00:00:00 CDT