Re: Improved sequence management

From: ddf <oratune_at_msn.com>
Date: Tue, 9 Nov 2010 12:22:21 -0800 (PST)
Message-ID: <70dfaf05-3c39-4a91-8453-caea4aa9d3af_at_r4g2000prj.googlegroups.com>

On Nov 9, 2:41 pm, "paddy_nyr" <philpott.patr..._at_gmail.com> wrote:
> What does this mean?
>
> How would I use a sequence value?
>
> A new features of Oracle 11g will bypass DML (sequence.nextval) and allow
> normal assignments on sequence values.

Old way:

declare

         p_seqval number;
begin

        select myseq.nextval into p_seqval from dual; end;
/

New way:

declare

        p_seqval number;
begin

        p_seqval := myseq.nextval;
end;
/

David Fitzjarrell Received on Tue Nov 09 2010 - 14:22:21 CST