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

what is table? : Sql dba

1109

What is a left join?

1006

Write the command to remove all players named sachin from the players table.

1227

What are instead of triggers?

1100

How many unique keys can a table have?

1066

What are some predefined exceptions in pl/sql?

1221

how many columns can be used for creating index? : Sql dba

986

Is natural join same as inner join?

984

What are the topics in pl sql?

1023

What is user in sql?

1074

What is the difference between count 1 and count (*) in a sql query?

1053

Can you inner join the same table?

1036

What is the difference between cross join and natural join?

1066

which operator is used in query for pattern matching? : Sql dba

1045

What are the advantages of sql?

1099