Re: Counter

On Feb 6, 9:20 am, gazzag <gar..._at_jamms.org> wrote:
> On 6 Feb, 15:04, "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
> > this:
>
> > 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!
>
> Look into Oracle sequences:
>
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/schema...
>
> HTH
>
> -g

Good suggestion....... Received on Wed Feb 06 2008 - 09:38:32 CST