Home » SQL & PL/SQL » SQL & PL/SQL » Wheter FORALL works for DML operations only (Oracle 10g)
Wheter FORALL works for DML operations only [message #383555] Thu, 29 January 2009 02:48 Go to next message
rakeshramm
Messages: 175
Registered: September 2006
Location: Oracle4u.com
Senior Member

Wheter FORALL works for DML operations only ?
Re: Wheter FORALL works for DML operations only [message #383556 is a reply to message #383555] Thu, 29 January 2009 02:55 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Yes. The documentation tells me:
Oracle docs
The FORALL statement issues a series of static or dynamic DML statements
So, you have execute immediate at your disposal too.

MHE
Re: Wheter FORALL works for DML operations only [message #383626 is a reply to message #383556] Thu, 29 January 2009 06:18 Go to previous message
rakeshramm
Messages: 175
Registered: September 2006
Location: Oracle4u.com
Senior Member

Thanks Maheer
Previous Topic: group the data on weeks starting from sunday
Next Topic: Multiple Flat File Generation in one spool
Goto Forum:
  


Current Time: Sat Dec 10 05:10:02 CST 2016

Total time taken to generate the page: 0.14326 seconds