Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
Tag: commit
DBMS_JOB is an asynchronous mechanism
One of the very cool things about DBMS_JOB is that a job does not “exist” as such until the session that submitted the job commits the transaction. (This in my opinion is a critical feature that is missing from the DBMS_SCHEDULER package which, other than…
