Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: "create or replace" for dbms_job

Re: "create or replace" for dbms_job

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sat, 12 Aug 2006 18:18:29 GMT
Message-ID: <Xns981D7308D616Fanacedenthotmailcom@70.169.32.36>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US