SQL/Oracle: select MYSEQ.nextval as MYSEQ from dual

KNIME Analytics Platform
1

I'm trying to retrieve the next (new) value for a sequence in an Oracle database. What node(s) should I use to execute a statement like "select MYSEQ.nextval as MYSEQ from dual" in KNIME? Thanks. Martin

2

Hi Martin,

you can use the Database Reader node for that with the "Run SQL query only during execute, skips configure" option selected.

Bye

Tobias

3

Thank you so much, Tobias!!!