Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL syntax for INSERT
This has helped tremendously. Thank You.
-- Randy Harris <davide_speed_at_davidebianchi.net> wrote in message news:acomm6$ra7je$1_at_ID-18487.news.dfncis.de...Received on Sat May 25 2002 - 15:09:43 CDT
> Randy Harris <randy.harris_at_nospam.net> wrote:
> > 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 SYSDATE, events.* FROM events WHERE...
>
> Davide