Daud,
if the statement is going to be static as in your example, it is
always better to avoid the Dynamic example and use the second snippet
in your example.
The reason is every dynamic SQL statement would result in a parse
call.
In your example you are using bind variables and the parse call will
most probably result in a soft parse. But still a soft parse results
in latching activity and should be avoided as far as possible.
As Daniel Morgan has pointed out There are good articles on this in
ASKTOM site.
regards
Srivenu
Received on Wed Mar 24 2004 - 00:27:18 CST
