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 [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
RE: Update ALL colums without knowing their name??-correction
Then do a Delete from table; which will remove all rows while leaving the previous data for the other users until you commit; [EMAIL PROTECTED] 07/24/01 03:35PM 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 [EMAIL PROTECTED] -Original Message- From: Csillag Zsolt [mailto:[EMAIL PROTECTED]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 This electronic mail (e-mail) and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. Personal views and opinions expressed in this communication are those of the originator and may not necessarily reflect those of O'Brien Gere and O'Brien Gere shall not be liable for any damage caused by or resulting from any such material. If you are NOT the original recipient or the person responsible for delivering the e-mail to the intended recipient, be advised that you have received this e-mail in error, and that any use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited. If you received this e-mail in error or any objectionable material, please delete it and immediately notify [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Update ALL colums without knowing their name??-correction
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 = ( Selectb.Every_columns from Table2where a.new_columns=b.new_columns ) where a.new_columns=(select b.new_columns from Table2where 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-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Csillag ZsoltSent: Wednesday, July 25, 2001 1:06 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Update ALL colums without knowing their name??-correctionHi,Thank you for your answer.Unfortunatelly I can't truncate, then insert into ... select ( I myself thought about it before )becausethe tables are always used ( there are always a few users connecting to database).Thank youZsolt Csillag HungaryAt 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 Zsoltwww.star-soft.hu