Re: oracle 8 and auto increment

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;
/

the output will be

1
2
3
...
etc.

Obviously you can build the PL/SQL block into a proper procedure etc. Received on Tue Mar 01 2005 - 08:01:02 CST