Subject Re: [Firebird-Architect] NBAK
Author Adriano dos Santos Fernandes
Dmitry Yemanov wrote:
> Roman Rokytskyy wrote:
>
>>> - flash back queries
>>>
>> Why do I need NBAK here? I always thought that this can be achieved by
>> providing a "flash back depth" parameter to garbage collector to prevent
>> garbage-collecting those records and providing the "flash back"
>> parameter with the query.
>>
>
> What about "flashing back" generator values? Would we want it? Does e.g.
> Oracle support it?
Do you mean the equivalent of GEN_ID(g, 0)?

Oracle does not have an equivalent of this. They have
sequence_name.currval, but this returns a per-session value of the last
sequence_name.nextval call.

--
Adriano dos Santos Fernandes
http://www.firebirdsql.org