Insert Sysdate into a table
469192Mar 1 2006 — edited Mar 1 2006Hello,
I created a table B that mirrors table A except that table B has a sysdate field. Now my intention is the following.
Insert into table B
select col1,col2,col3 from table A where col1 = v_col1;
table B should contain everything from table A along with sysdate (when it was inserted),
any ideas?
thanks
Sam