db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jean T. Anderson" <...@bristowhill.com>
Subject Re: can derby have a "sequence" column?
Date Sat, 17 Sep 2005 14:56:40 GMT
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* <jta@bristowhill.com 
> <mailto:jta@bristowhill.com>> 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
> 
> 


Mime
View raw message