Home -> Usenet -> comp.databases.oracle -> Inserting Records Based On A Select Statement

Inserting Records Based On A Select Statement

From: Simon Taylor <simontaylor1_at_csi.com>
Date: 1997/12/29
Message-ID: <01bd149b$234bd2a0$c806e8c3_at_simontay>#1/1 







I have a need to insert records into a table based upon records that are
already there.


The closest I can get to it is


INSERT into 	<tablea>
SELECT 	(cola,colb,colc)
FROM		<tablea>
WHERE	criteria





What I want to do is modify the values I am inserting before they are
inserted.



Is there any way I can perform a combination of the INSERT into <tables>
VALUES() and the above statement.


I have alpha characters and dates that need to be modified and COL-<number>
doesn't seem appropriate.



T.I.A


-- 




-- 



Simon Taylor
Received on Mon Dec 29 1997 - 00:00:00 CET












Original text of this message