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

Home -> Community -> Usenet -> c.d.o.server -> Re: finding dates are not in table

Re: finding dates are not in table

From: Peter McKenzie <pemmck_at_ibm.net>
Date: 1997/07/30
Message-ID: <5rm7co$1hq$1@marri.bs.wa.gov.au>#1/1

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

Original text of this message

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