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
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
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
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
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
Check the connection to the database using the entered values
Connect to Oracle database using entered values
Save connection parameters for later use
Delete selected connection
Load db report
-> Request to retrieve data <-
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,
where l.GROUP# = lf.GROUP#
group by bytes;
select name, round (value / 1024 / 1024.2) || 'MB' "MB" from V$SGA;