Re: Counter
From: EdStevens <quetico_man_at_yahoo.com>
Date: Wed, 6 Feb 2008 17:19:24 -0800 (PST)
Message-ID: <d724599d-8b01-47df-9311-3fdf74f96f58@u10g2000prn.googlegroups.com>
Date: Wed, 6 Feb 2008 17:19:24 -0800 (PST)
Message-ID: <d724599d-8b01-47df-9311-3fdf74f96f58@u10g2000prn.googlegroups.com>
On Feb 6, 9:53 am, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
<snip>
> Using a sequence is probably the only reliable method of implementing
> a row (record) counter. Of course this also involves changing your
> insert statement from a values list to an insert ... select statement.
>
Not necessary to INSERT ... SELECT
This example from PL/SQL User's Guide and Reference
INSERT INTO employees_temp VALUES (employees_seq.NEXTVAL, 'Lynette', 'Smith'); Received on Wed Feb 06 2008 - 19:19:24 CST