Calling a database sequence from DQL

Hi all,

Is it possible to call a database sequence from DQL? I added the sequence directly on the Oracle database (so using an Oracle client and executing a statement like CREATE SEQUENCE .... etc.). Now to call this sequence from DQL, I can't obviously do things like this:

select <sequence_name>.nextval from dual;

Does anybody know how you can call a sequence, if it is possible at all?

Thanks in advance.

Find more posts tagged with

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

documentum1

try this

select <sequence_name>.nextval from sys.dual

All comments

documentum1

try this

select <sequence_name>.nextval from sys.dual

bpiepers

Thank you! This was the correct answer.