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).