SQL Editor [PL/SQL] for Oracle Database

Editor  SQL/PLSQL  for DBMS  Oracle allows you to quickly and conveniently work with databases, administer and monitor work. 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

query editor - dashboard 5
query editor - dashboard 5

press to zoom
query editor - dashboard 1
query editor - dashboard 1

press to zoom
query editor - dashboard 2
query editor - dashboard 2

press to zoom

Creating a new sheet


  1. By clicking the "New list for Oracle"

  2. File - New - Oracle

  3. Keyboard shortcut: Shift + F1

  4. By cloning the current sheet: Ctrl + t

create new page for Oracle.jpg

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


Sheet structure

Connection manager
Connection manager for Oracle.jpg
Connection list

List of previously saved connections

Connection parameter tab


Or block name from tnsnames.ora file or connection string in the format: host:port/service_name

"Local TNS editor" button

Tnsnames.ora local file editor


Username under which to connect to the database


User password under which to connect

New password

Change the password to the specified one. After changing the password (the "Change password" button), copy it into the "Password" field and save the changes


Connection mode

Switch "Load db report"

After connecting to the database, generate a short report on the status of the database

TNS settings tab

Vendor lib (oci.dll)

The full path to the oci.dll file from the Oracle client installed directory


Directory on disk with tnsnames.ora file


Client encoding parameters

Test button

Check the connection to the database using the entered values

Connect button

Connect to Oracle database using entered values

Save button

Save connection parameters for later use

"Delete" button

Delete selected connection

Load db report

-> Request to retrieve data <-

select instance_name,
  from v$instance;

select name,
from v$database;

select count(*) "Count" from V$TABLESPACE;

select count(*) "Count",
       round (sum(bytes/1024/1024/1024), 2) || ' GB '"SizeFile"

select count(*) "Count" from ALL_USERS;

select count(distinct(l.group#)) "Count",
       round(l.bytes / 1024/1024) "MB",
       count(lf.GROUP#) / count (distinct (l.group#)) "File"
  from V$LOG l,
       V$LOGFILE lf
where l.GROUP# = lf.GROUP#
group by bytes;

select name, round (value / 1024 / 1024.2) || 'MB' "MB" from V$SGA;