Re: oracle 8 and auto increment

"stephen O'D" <stephen.odonnell_at_gmail.com> wrote in message news:1109685662.584256.27320_at_l41g2000cwc.googlegroups.com...
| Something like this will work:-
|
| create sequence mytestseq start with 1 increment by 1 minvalue 1;
|
| create table t (id integer, text varchar2(50));
|
| set serveroutput on
|
| declare
| new_id integer;
| begin
| insert into t (id, text) values (mytestseq.nextval,'test entry')
| returning id into new_id;
|
| dbms_output.put_line (new_id);
| end;

Thanks! I was able extract the number by

select mytestseq.currval from dual;

-Thorsten Received on Tue Mar 01 2005 - 08:40:09 CST