Re: Bug in 3.1.6 ?
Posted by: R Lenard
Date: January 11, 2005 10:36PM

Harrison Fisk wrote:
> Hi,
>
> I don't think your statement will work the way you
> want.
>
> REPLACE INTO summaryTable ( f1, f2, f3 ) SELECT ?
> AS f1, ? AS f2, CURRENT_TIMESTAMP AS f3 FROM
> origTable WHERE f2 = ?
>
> The first two ? will be replaced with constants.
> You can't specify column names in that manner. If
> you want them to be constants then you will be
> fine.
>

I actually have about 10 fields but I don't see that they would be relevant at all.

The constant-ness is fine - it's only constant per set of params.

Options: ReplyQuote


Subject
Written By
Posted
January 11, 2005 08:52PM
January 11, 2005 09:55PM
January 11, 2005 10:03PM
January 11, 2005 10:26PM
January 11, 2005 10:28PM
January 11, 2005 11:31PM
January 11, 2005 10:06PM
January 11, 2005 10:13PM
January 11, 2005 10:17PM
January 11, 2005 10:28PM
January 11, 2005 10:30PM
Re: Bug in 3.1.6 ?
January 11, 2005 10:36PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.