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.

On Nov 9, 2:41*pm, "paddy_nyr" <philpott.patr... (AT) gmail (DOT) com> wrote:
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

On Tue, 09 Nov 2010 14:41:14 -0500, paddy_nyr wrote:

This is what it means:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing
options

SQL> create sequence test_seq start with 1 cache 2048;

Sequence created.

Elapsed: 00:00:00.09
SQL> declare
2 a number(10,0);
3 begin
4 a:=test_seq.nextval;
5 dbms_output.put_line('A is:'||a);
6 end;
7 /
A is:1

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.07
SQL> /
A is:2

SQL> save /tmp/1
Created file /tmp/1.sql
SQL> connect scott/tiger@stag3
Connected.
SQL> create sequence test_seq start with 1 cache 2048;

Sequence created.

Elapsed: 00:00:00.15
SQL> @/tmp/1
a:=test_seq.nextval;
*
ERROR at line 4:
ORA-06550: line 4, column 13:
PLS-00357: Table,View Or Sequence reference 'TEST_SEQ.NEXTVAL' not
allowed in
this context
ORA-06550: line 4, column 1:
PL/SQL: Statement ignored


Elapsed: 00:00:00.10
SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for Linux: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production

Elapsed: 00:00:00.13



--
http://mgogala.byethost5.com