Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Update ALL colums without knowing their name??-correction

RE: Update ALL colums without knowing their name??-correction

From: Csillag Zsolt <starsoft_at_interware.hu>
Date: Tue, 24 Jul 2001 11:56:50 -0700
Message-ID: <F001.00353A0F.20010724113558@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US