Топ-100
 
CerebroSQL

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

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
1/5
 

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