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: Data into another table

Re: Data into another table

From: Tim Sawmiller <sawmillert_at_state.mi.us>
Date: Wed, 21 Mar 2001 10:49:38 -0800
Message-ID: <F001.002D37CB.20010321095626@fatcity.com>

Time to take a class dude... :-)

insert into new_salary_table (new_salary) select (t1.salary * 1.10) from salary_table t1 /

a 10% increase is pretty good these days.....

>>> Roland.Skoldblom_at_ica.se 03/21/01 10:50AM >>>
How can I create a select statement from table1 including some division or multiplication , and then include the result into table2.

Roland Sköldblom

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author:
  INET: Roland.Skoldblom_at_ica.se 

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

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Tim Sawmiller
  INET: sawmillert_at_state.mi.us

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 Wed Mar 21 2001 - 12:49:38 CST

Original text of this message

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