Re: how do I purge data from a database table

And at least one other will agree.

Especially when his title is: "Oracle team leader"

Ouch!

Daniel Morgan

Alan wrote:

> 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 - 13:22:40 CDT