phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ravi Kiran <>
Subject Re: REG: Getting the current value of a sequence
Date Sat, 22 Aug 2015 17:27:45 GMT
Hi Satya,

  Unless you call NEXT VALUE FOR on a sequence *the first time*, you
wouldn't be getting the CURRENT VALUE .   So , instead of getting the
CURRENT VALUE, you can get the NEXT VALUE and then pass to your upsert

Hope this helps

On Sat, Aug 22, 2015 at 7:59 AM, Ns G <> wrote:

> Hi All,
> I have a requirement where the sequence number is to be prefetched and
> then used in upsert query.
> I know that Current Value for a sequence number gives me the last used
> value. But It does not return value for the first time until and unless
> used in a upsert query.
> Is there any alternative to get the sequence immediately after declaration
> and before using in a upsert query?
> Thanks,
> Satya

View raw message