Hi,
I don't know whether this will serve
your needs !
If you
are using oracle8i then you can make relation between this two tables by adding
common column.
And
then giving statement (ex/ new_columns is the column relating two
tables)
Update Table1 a set a.Every_columns = ( S
Then do a
Delete from table;
which will remove all rows while leaving the previous data for the other users until
you commit;
>>> [EMAIL PROTECTED] 07/24/01 03:35PM >>>
Hi,
Thank you for your answer.
Unfortunatelly I can't truncate, then insert into ... select ( I myself
thought about it b
Hi,
Thank you for your answer.
Unfortunatelly I can't truncate, then insert into ... select ( I myself
thought about it before )because
the tables are always used ( there are always a few users connecting to
database).
Thank you
Zsolt Csillag
Hungary
At 13:52 2001.07.23. -0800, you wrote:
A