-
Book Overview & Buying
-
Table Of Contents
Oracle SQL Developer 2.1
By :
The utilities discussed in this section can once again be used in either the SQL Worksheet or the Code editor. While all are not necessarily confined to PL/SQL, such as the Find DB Object search utility, it is useful to discuss them here.
Refactoring code is the process of redesigning the code to restructure it or improve the performance, without impacting the resulting behavior. SQL Developer 2.1 supports a number of refactoring options, which include:
Surrounding the code with the following PL/SQL constructs
FOR loop
WHILE loop
PL/SQL block
Extracting a procedure
Renaming a local variable
Some of these can assist you while writing your code, such as Surround with…, and so are as much about being productive as they are about refactoring. One feature that is useful when refactoring is Extract Procedure….
When you are creating PL/SQL code, it is often recommended that you create chunks of code that you can call from another program unit. This introduces reusability...
Change the font size
Change margin width
Change background colour