Text from book where isbn isbn begin for review review loop review

Term Fly Presents http://www.flyheart.com

string expression, or I am ready to absorb the overhead of multiple implicit conversions, I should use TRUNC to get rid of the time element.

	Since my summary_title_in argument never changes, I shouldn't UPPER case in each iteration of the loop. Rather than check the length of the text for each row and then SUBSTR (and UPPER case), why not just SUBSTR inside SQL?

	You can, in general, expect the performance of built-in functions such as SUBSTR to work more efficiently in SQL than in PL/SQL, so move the processing to the SQL layer whenever possible.

Benefits

that the cycles saved on this optimization are never noticed by the user. You are always better off saving the bulk of your optimization efforts until you have identified the bottlenecks in your application as a whole.

Resources

One of the nice things about PL/SQL is that you, the developer, can define any set of executable statements as a distinct block, with its own declaration, executable, and exception sections.

If you notice that certain operations and data structures aren't needed unless a certain condition is satisfied, move all the execution of those operations and the declaration of those data structures inside the conditional statement. The result is that you won't incur the overhead (CPU or memory) unless it's absolutely needed.

END IF;
END;

76

Over 10 Million Study Resources Now at Your Fingertips