Oracle SQL and PL/SQL Editor
The Oracle SQL and PL/SQL editor provided by RazorSQL has many features for SQL and PL/SQL development. It allows users to edit, create, and drop PL/SQL procedures, functions, packages, package bodies, and triggers. It will also display any errors thrown by Oracle when creating or editing PL/SQL code. Also included in the editor are the features listed below.
- PL/SQL syntax highlighting
- PL/SQL function lookup for built-in PL/SQL functions and the SYS packages provided by Oracle such as DBMS_OUTPUT, etc.
- SQL syntax highlighting
- Auto table lookup and completion
- Auto column lookup and completion
- Extensive find, replace, and find / replace in files functionality
- Bracket, parenthesis, and brace auto matching
- Support for parameterized queries
- SQL Formatter
- Execute, Execute Fetch All, and Execute Batch functions
- Multi-Tabular Display of Query Results
- Sortable Query Results
- Filterable Query Results
- Searchable Query Results
- SQL History for All Queries, and Query Logging Per Connection
- Query navigator for displaying a clickable display of queries in the editor
- Key Ahead functionality for one-click population of user-defined text
- Built-in and Custom User Templates
- Connection Keep-Alive
- Plugin API (Allows users to add custom functionality to RazorSQL)
The Oracle SQL and PL/SQL editor will automatically configure PL/SQL specific syntax highlighting on connection to an Oracle database. This gives users the ability to do function lookup on PL/SQL functions, etc. Upon connection to an Oracle database, the editor also activates such features as the ability to view DBMS output.
