Hi Krishna,
If you dont have a date column, then on what basis you would be deleting
data older than 6 months.
As i mentioned earlier, if the no. of records in the table is less then you
can use direct delete statment.
On 7/5/07, krishna chandra prajapati <[EMAIL PROTECTED]> wrote:
Hi All,
So
Hi Anand,
Some of the tables have the date column. what if the table doesn't have the
date column. The number of table in the database is more than 200. What else
is possible.
Is there is any other way to do this except stored procedure
Regards,
Krishna
On 7/5/07, Ananda Kumar <[EMAIL PROTECTED
Hi Krishna,
You can write a stored proc, where, in the main cursor, select column having
unique value for the records to be deleted,
For example
select item_id from table_name where< sysdate - 180.
This cursor will give you value of a column older than 180 days,
and inside the main stored
