struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Chacón Sánchez" <danielc...@gmail.com>
Subject Re: Out of topic, Oracle SEQUENCE
Date Fri, 15 Sep 2006 16:33:56 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message