Home » SQL & PL/SQL » SQL & PL/SQL » What is the switching context with FORALL? (Oracle 11gr2)
What is the switching context with FORALL? [message #648000] Sun, 14 February 2016 10:44 Go to next message
Ikebukuro
Messages: 2
Registered: February 2016
Junior Member

Hello every body,

I have a big question about what is the switching context between PLSQL engine and SQL engine.
Sometimes I use FORALL when I have to execute many time a same SQL order in a PLSQL procedure.

My question is : what is exactly the switching context? If I don't use FORALL, this switching context will be executed many time and it is a bad thing. So I use FORALL but I am curious and I want to know what is exactly the problem with that switching : I/O problem, memory problem...

Thank you very much for yours answers.
Re: What is the switching context with FORALL? [message #648001 is a reply to message #648000] Sun, 14 February 2016 11:08 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

are you unwilling or incapable to use GOOGLE yourself?

https://www.google.com/search?q=switching+context+between+PLSQL+engine+and+SQL+engine

Why do you want to read answer here and not where it already exists?
Previous Topic: Can any one help to remove duplicate rows in a table
Next Topic: truncating a empty table
Goto Forum:
  


Current Time: Thu Mar 28 06:09:06 CDT 2024