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

From: William Beilstein <BeilstWH_at_obg.com>
Date: Tue, 24 Jul 2001 12:41:04 -0700
Message-ID: <F001.00353B5C.20010724122050@fatcity.com>

Then do a

Delete from table;

which will remove all rows while leaving the previous data for the other users until you commit;

>>> starsoft_at_interware.hu 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
>jcb_at_netsec.net
>
>-----Original Message-----
>From: Csillag Zsolt
>[<mailto:starsoft_at_interware.hu>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

---

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 "Postmaster_at_Obg.Com"

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: William Beilstein
  INET: BeilstWH_at_obg.com

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: ListGuru_at_fatcity.com (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).

Received on Tue Jul 24 2001 - 14:41:04 CDT