INSERT INTO (SELECT ....... Problems

[notrut]

Hi,

I'm trying to do an insert using a select statement for an Oracle database.

I want to copy a set of records from the same table but with different values for some of the fields. (i.e. different dates)

Is this possible without having to insert each record separately???

 

[karluk]

Absolutely. An example would be a two column table (col1, last_update) where you select col1 from another table, but set last_update to the current date. You insert would look like

insert into your_table (select col1, sysdate from another_table);