document.write('
Data hosted with ♥ by Pastebin.com - Download Raw - See Original
  1. SELECT MAX(empno)
  2. INTO   :new_empno
  3. FROM   emp;
  4.  
  5. INSERT INTO emp
  6. VALUES (:new_empno + 1, ...);
  7.  
  8.     --atau dengan mengunakan sequence
  9. INSERT INTO emp
  10. VALUES (emp_seq.NEXTVAL, ...);  
  11.  
  12. SELECT emp_seq.NEXVAL
  13. INTO   :new_empno FROM dual;
');