Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Update ALL colums without knowing their name??-correction
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:
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?
Csillag Zsolt
www.star-soft.hu Received on Tue Jul 24 2001 - 13:56:50 CDT
![]() |
![]() |