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