Re: Delete Data older than exactly 2 years

On 4/19/07, Sanjay Mishra <smishra_97_at_yahoo.com> wrote:
>
>
> Can somebody suggest good method to delete all record older than 2 years
> from the current date. This script will run on the last sunday of each
> month. I will write the logic for Last sunday in Unix shell but need some
> idea about the SQL. I can't use some 365+366 or so kind of logic. THis is
> 9i.
>
>

Please see http://www.catb.org/~esr/faqs/smart-questions.html#before

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l