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;
SELECT col1, co2, col3, (select TEST_SEQ.NEXTVAL) SEQ
Don't use a sub-select:
SELECT col1, co2, col3, TEST_SEQ.NEXTVAL as SEQ FROM table;