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 -> Re: SQL syntax for INSERT

Re: SQL syntax for INSERT

From: Randy Harris <randy.harris_at_nospam.net>
Date: Sat, 25 May 2002 20:09:43 GMT
Message-ID: <bcSH8.4754$t%5.1573858@newssvr28.news.prodigy.com>


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...

> 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
Received on Sat May 25 2002 - 15:09:43 CDT

Original text of this message

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