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:
Are you just trying to totally refresh table1 from table 2?
how about:
1. TRUNCATE table1;
2. INSERT INTO table1 SELECT * FROM table2;
(assuming structures of the two tables are compatible)
Or am I just totally missing the mark in what you are looking to do?
Jon
[EMAIL PROTECTED]
-----Original Message-----
From: Csillag Zsolt [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 23, 2001 5:33 PM
To: Multiple recipients of list ORACLE-L
Subject: Update ALL colums without knowing their name??
Hi,
I need an universal update procedure in which I don' t know the colums name.
How can I make an update like this:
Update Table1 set Every_columns = ( Select * from Table2)
I tried set Table1.* wiht no result.
How can I work around this?
Csillag Zsolt
www.star-soft.hu
