Date: Wed, 6 Feb 2008 07:40:26 -0800 (PST)
On Feb 6, 10:04 am, "ame..._at_iwc.net" <ame..._at_iwc.net> wrote:
> Hi All,
> I'm looking around right now to see if this is possible, but I thought
> I'd ask here too.
> Can you have a record counter in an insert statement? Something like
> INSERT INTO table_a (
> SELECT flda, fldb, fldc, i++, fldd FROM tableb);
> Basically there is one column that is a record counter. And since
> this is not a loop, I'm not sure how it is done. Maybe a sub-select
> with a count(*)??
> Thanks a bunch!
Why not just use rownum?
Steve Received on Wed Feb 06 2008 - 09:40:26 CST