
SQL Editor [PL/SQL] for Oracle Database
Editor SQL/PLSQL for DBMS Oracle allows you to quickly and conveniently work with databases, monitor and administer. The editor supports Oracle server versions 8.0.3 and older
Didn't find the features you need? Write in the comments on forum and we will add the necessary functionality
To work with Oracle DBMS, installation of additional software is not required.
All required libraries are included
The default library version is 11G
Create a new sheet
Connection to Oracle DBMS
Sheet structure
Creating a new sheet
-
By clicking the "New list for Oracle"
-
File - New - Oracle
-
Keyboard shortcut: Shift + F1
-
By cloning the current sheet: Ctrl + t

Connecting to Oracle DBMS
1. Select a previously saved connection from the drop-down list "Connection control"
2. By running the connect ... command in the query editor.
Command structure: connect <username>/<Password>@<TNSALIAS>
Example: connect sys/oracle@tmpdb
ps: specifying the as sysdba mode is not required, the program parses the command into parts and checks the entered parameters
3. In the editor of the sheet-to-database connection