Oracle PL/SQL Auto Completion
The Oracle SQL and PL/SQL editor provided by RazorSQL includes auto completion and auto lookup for Oracle packages, such as the built-in packages included with Oracle. Listed below are some examples of the PL/SQL editor's auto completion tools.
The following image shows how the PL/SQL editor contained in RazorSQL displays Oracle packages. This information can be displayed with the lookup option on the toolbar.
The following displays how the PL/SQL editor will auto complete Oracle built-in package information. For example, if the user types DBMS_OUTPUT., the PL/SQL editor will then display all of the procedures and functions available in the DBMS_OUTPUT package.
The following shows how the Oracle PL/SQL editor will display the necessary parameter information for the procedure or function that was selected from the auto complete process.