Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> SQL syntax for INSERT
I'm hoping there is a conventional (read easy) method of doing this. I wish
to selectively move records from one table to another.
INSERT INTO events_deleted
SELECT * FROM events WHERE eventID=4659;
This works, however I would like to also add the SYSDATE to the resulting record. If I add a DATE field to the destination table the above INSERT no longer works. I've tried things like:
INSERT INTO events_deleted
SELECT * FROM events WHERE eventID=4659, SYSDATE ;
Is there some way to do this?
TIA
-- Randy HarrisReceived on Sat May 25 2002 - 13:51:25 CDT