I would like to use the same sequence number across multiple select statements in SQL form to eventually use it as a PK insert in a table and tie multiple records together.
So far, I can only select the NEXTVAL from dual:
SELECT TEST_SEQ.NEXTVAL AS SEQ FROM DUAL;
However, when I include the sequence into a multiple column select, I get sequence not allowed here error.
SELECT col1, co2, col3, (select TEST_SEQ.NEXTVAL) SEQ
FROM table;
Any help is greatly appreciated.