To reduce the context switches between the SQL Engine and PL/SQL engine.

How to improve the performance of a pl/sq stored procedures
or functions or triggers and packages ?

Question Posted / hrishi

Answer Posted / hrishi

To reduce the context switches between the SQL Engine and
PL/SQL engine. We can use Bulk Bind Concept to this...

Is This Answer Correct ?

6 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How can you fetch first 5 characters of the string?

946

Can I call a procedure inside a function?

945

what are null values? : Sql dba

899

Is left join same as inner join?

1021

Which table is left in join?

913

How do I write a cron which will run a sql query and mail the results to agroup?

911

differentiate between float and double. : Sql dba

988

What are the parameter modes supported by pl/sql?

1019

How does pl sql work?

912

What are field types?

939

What does the hierarchical profiler does?

1003

what is the command line end user interface - mysql? : Sql dba

925

What is cross join example?

940

Explain alias in sql?

993

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

920