Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQL syntax for INSERT

SQL syntax for INSERT

From: Randy Harris <randy.harris_at_nospam.net>
Date: Sat, 25 May 2002 18:51:25 GMT
Message-ID: <N2RH8.4746$t%5.1568528@newssvr28.news.prodigy.com>


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 Harris
Received on Sat May 25 2002 - 13:51:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US