Thanks so, first:
insert into users_values (user_seq .nextval, 'userName');
and then:
select user_seq.curval from dual
There is not a way to make only one sentence to do that? Like in SQL 2000:
SET NOCOUNT ON INSERT INTO
USER_VALUES
(USER_NAME)
VALUES ('DANIEL')
*SELECT @@IDENTITY* as userCode SET NOCOUNT OFF
