how do you write a query or a macro that automatically copy an oracle table and rename it each week to do a comparison?

thanks

how do you write a query or a macro that automatically copy an oracle table and rename it each week to do a comparison?

thanks

Copying it is easy

Insert Into {YourNewTableName}
Select * From {YourOldTableName}
{ Where {Any Relevant conditions} }


Note that the Where Clause is optional and used only if it is required.

Comparison would have to be defined by the contents of the data

Copying it is easy
[code]
Insert Into {YourNewTableName}
Select * From {YourOldTableName}



Would this delete all the old data?

No it would not. I presumed that your copy of the table was to be into a NEW table that had no records. You can always Delete From YourNewTableName if you need to remove old records first.

Thank you!