ТЕМА:

create table test (

    test_id number(9)

  , name varchar2(32)

  , constraint pk_test primary key (test_id)

)

/



create sequence sq_test;

insert into test (test_id, name)

values (sq_test.nextval, :name)

return test_id into :test_id;

select sq_test.nextval into :test_id from dual;

insert into test (test_id, name)

values (:test_id, :name)

create or replace trigger tbiur_test

before insert or update on test

for each row

begin

  if :new.test_id is null then

    select sq_test.nextval into :new.test_id from dual;

  end if;

end;

/



insert into test (name)

values ('name2')

return test_id into :test_id;