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

Reply via email to