-
Debugging Dynamic SQL
What is the best technique of debugging large and fragmented dynamic SQL.
shivaranjani.p
- Oct 6th, 2010
Hi,You need to store each and every line of the dynamic sql in a file using UTL_FILE Package before you could execute it, so that you can refer the same file after executing the code, this here serves...
-
DeCode Performance
Performance wise which is a better option if-else construct or a decode? Why
muraligrandhi
- Jun 7th, 2010
DECODE is faster than IF-THEN-ELSEREASON:Decode is an Oracle built-in function, so no need to pass parameters to this function. Because all the parameters are internally defined but If-then-else statements we should define explicitly, so takes time for execution and converting into P-code.
sanjeevlabh
- Jan 22nd, 2010
The answer to this question would actually depend on the type of applicability of the usage that is being done. i.e. is it required in a query or in a PLSQL block. If it is in a query we cannot use if...
