Skip to content

Instantly share code, notes, and snippets.

@mikebeaton

mikebeaton/AnotherAnswer2.sql

Created September 3, 2019 15:38
Show Gist options
  • Save mikebeaton/cc7dcade603cd175f9be7b23cd9f152a to your computer and use it in GitHub Desktop.
Save mikebeaton/cc7dcade603cd175f9be7b23cd9f152a to your computer and use it in GitHub Desktop.
Download ZIP
'Another Answer' article, gist #2
Raw
AnotherAnswer2.sql
INSERT INTO SCOTT.DEPT (DNAME, LOC, DEPTNO)
VALUES (:DNAME, :LOC, SCOTT.DEPT_SEQ.nextval);
SELECT SCOTT.DEPT_SEQ.currval FROM DUAL;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment