Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: "create or replace" for dbms_job
"dn.perl_at_gmail.com" <dn.perl_at_gmail.com> wrote in
news:1155402522.094600.265490_at_b28g2000cwb.googlegroups.com:
> Query # 2 : Correct me if I am wrong but the dbms_job has
> an air of 'DDL' about it; why should it be necessary to commit
> the creation or deletion of a dbms_job?
You are wrong.
You are simply doing DML; entering data into a table.
Other sessions do not "see" your data until after a COMMIT is done.
Received on Sat Aug 12 2006 - 13:18:29 CDT