Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

which one is better

ASK_NMNov 25 2011 — edited Nov 29 2011
When we want update more than 100 million records, using bulk update is better or merge statement is better, ? when i used bulk statement it took 24 sec to update 10,000 records and when i used merge it took only 89 milli seconds, what is the difference between them ?

Comments

user11440683

Hi,

you can have timed agents that run based on a condition being true, so you could have your dashboard prompt set a presentation variable and the presentation variable be used in an analysis which is used as the basis for evaluating if the agent should run which sends the report.

So yes doable.

Btw - do give yourself a user friendly name it makes board users more likely to engage with you!

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 27 2011
Added on Nov 25 2011
10 comments
189 views