select sequence.nextval into 'variable' from dual

use the variable in your insert statements