Select GEN_ID(MySequence,1) from RDB$DATABASE;

This increments the value of MySequence by 1. If you dont want to increment then use GEN_ID(My_Sequence,0) but there are usually
no good reasons to simply POLL the value of a generator, unless you are simply curious.

MySequence would be a generator created with the CREATE GENERATOR metadata statement.

a GENERATOR is essentially the same thing as an Oracle SEUQUENCE except that the act of checking the value of the generator can
cause the generator to be incremented by any chosen amount (or decreased, or left alone), whereas if memory serves Oracle defines the amount of the
increment at the time the SEQUENCE is created and it can't be controlled afterwards.

> Zhibin Sun wrote:
>
>
>>Hi ib-support: what's sql statement in interbase for "select MySequence.nextval from dual" in Oracle? best regards. S.Wolf
>>