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

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

Hi Martin,

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



Thank you so much, Tobias!!!