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:17:29 CDT
