Hi,
I don't know whether this will serve
your needs !!!!!
If you
are using oracle8i then you can make relation between this two tables by adding
common column.
And
then giving statement (ex/ new_columns is the column relating two
tables)
Update Table1 a set a.Every_columns = ( Select b.Every_columns from
Table2 where a.new_columns=b.new_columns ) where a.new_columns=(select
b.new_columns from Table2 where a.new_columns=b.new_columns
.
Then
dropping that column named new_columns.
I
don't know how You can make a procedure with this?????????
BFN.
Jaimin.
-----Original Message-----Hi,
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Csillag Zsolt
Sent: Wednesday, July 25, 2001 1:06 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Update ALL colums without knowing their name??-correction
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
