RE: Update ALL colums without knowing their name??

From: Jon Baker <jcb_at_netsec.net>
Date: Mon, 23 Jul 2001 13:32:57 -0700
Message-ID: <F001.00352989.20010723135222@fatcity.com>

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
jcb_at_netsec.net

-----Original Message-----
From: Csillag Zsolt [mailto:starsoft_at_interware.hu] 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? Received on Mon Jul 23 2001 - 15:32:57 CDT