The IDENTITY_VAL_LOCAL function returns the most recently assigned number:
http://db.apache.org/derby/docs/10.1/ref/rrefidentityvallocal.html#rrefidentityvallocal
cheers,
-jean
Mag Gam wrote:
how do you get the last serial used in a table?
On 9/16/05, *Jean T. Anderson* <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
firstname lastname wrote:
> If I remember correctly, Oracle can define a column as being a
> "sequence", which is a garaunteed unique integer for each record. Can
> derby do this? A create table example would be nice.
Derby supports generated "identity" columns; examples are here:
http://db.apache.org/derby/docs/10.1/ref/rrefsqlj37836.html
<http://db.apache.org/derby/docs/10.1/ref/rrefsqlj37836.html>
regards,
-jean
