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 query.
Hope this helps On Sat, Aug 22, 2015 at 7:59 AM, Ns G <[email protected]> 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 >
