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?
