One could argue that if he has to ask, he shouldn't be doing it...
"Dusan Bolek" <pagesflames_at_usa.net> wrote in message
news:1e8276d6.0204120817.16626638_at_posting.google.com...
> willjamu_at_mindspring.com (James Williams) wrote in message
news:<3cb6bb7b.39967927_at_nntp.mindspring.com>...
> > On 12 Apr 2002 03:15:01 -0700, ekearney_at_ddsi.ie (Edel) wrote:
> > Describe you table and see if you have a column with date format.
> > Then
> > Delete from table where datecol < sysdate-180;
>
> That was an excelent advice. With some bad luck a "column with date
> format" that he'll found will be something like CUSTOMER_FIRST_CONTACT
> and all customer table will be empty in no time. :-)
> I think that before deleting something in table, user SHOULD know what
> meaning has a table and all columns in and not just go and see if a
> column have a date format.
>
> --
> _________________________________________
>
> Dusan Bolek, Ing.
> Oracle team leader
>
> Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
> can call it an overture to bankruptcy) on that server. I'm still using
> this email to prevent SPAM. Maybe one day I will change it and have a
> proper mail even for news, but right now I can be reached by this
> email.
Received on Fri Apr 12 2002 - 11:53:58 CDT
