Re: Data into another table

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