On Tue, May 24, 2005 at 13:49:40 -0300,
jjeffman@xxxxxxxxx wrote:
>
> Another feature I missed is the "returning" clause
> of the Oracle "INSERT" SQL command, which allow the
> user to retrieve the "serial" value after an insert
> command, which works even in a concurrent network
> environment.
While it might be nice to have a returning clause (and there has been
discussion of that in the past), you can do what want.
The currval function returns the last value assigned by nextval in
the current session and is safe from conflicts with concurrent operations.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
