How can I create a select statement from table1 including some division or
multiplication , and then include the result into table2.
Roland Skldblom
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858)
Roland,
Just like this...
Insert Into Table2 ( Col_12 , Col_34 )
Select Col1 * Col2 , Col3 / Col4 From Table1 ;
Of course Col_12 and Col_34 must be datatype Number.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
insert into table2 (col1, col2)
select col4*2, col7/8
from table1;
-Original Message-
Sent: Wednesday, March 21, 2001 10:51 AM
To: Multiple recipients of list ORACLE-L
How can I create a select statement from table1 including some division or
multiplication , and then include the
insert into table2 (col1, col2 )
select col1, col2 * col3 / col4
from table1
hth
connor
--- [EMAIL PROTECTED] wrote: How can I create
a select statement from table1
including some division or multiplication , and then
include the result into table2.
Roland Skldblom
--
Please see the
Title: RE: Data into another table
In my last sentence, I meant SALES! I do not profit from any book SALES made by fatbrain(tm).
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
How can I create a select statement from table1 including
some division