insert into ... select *

Hi,

I would like to extend the following statement: insert into table_arch select * from table_runtime where order_number = 'abc';

table_arch got a new field (a date field, with a creation timestamp). So it has one field more than table_runtime. The problem is: i don't have any idea how to fill this additional field within one statement. Could you give me a hint how the new statement should look like ?

(And: i know how to get the current date: select sysdate from dual ;-)

thank you,
Rainer Received on Tue Apr 29 2003 - 01:23:08 CDT