Re: Inserting Records Based On A Select Statement

You can do the following:
insert..
select decode(cola,1,2,3,4,4), nvl(colb, 'a'), .... from tabel
where..

Simon Taylor wrote in message <01bd149b$234bd2a0$c806e8c3_at_simontay>...
>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 Tue Dec 30 1997 - 00:00:00 CET