Free Oracle SQL Client

Oracle Database is a proprietary multi-model database management system produced and marketed by Oracle Corporation.
qStudio is a free SQL Client, it allows running SQL scripts, easy browsing of tables, charting and exporting of results. It works on every operating system, with every database including Oracle.

Start Oracle
Connecting to Oracle
Querying Oracle

Setting up a Oracle connection in qStudio

Start Oracle

Oracle is available on AWS Cloud. Simply start a small service in your chosen region. The connection details should be provided, similar to shown:

Engine type: Oracle
Public access: Yes
VPN: With access permitted from our IP address.

Connecting to a Server

QStudio includes an Oracle driver.

When you first open qStudio click on the menu options Server->Add Server or on the add server button on the toolbar.
Then set the details:

Server Type: Oracle
Host: database-1.ctayqjdfp8vl.eu-west-1.rds.amazonaws.com
Port: 1521
Database: ORCL
Username: admin
Password: XXXXXXXXXXX
Click Add

Sending Queries

// Oracle JDBC only supports running one statement at a time

CREATE TABLE IF NOT EXISTS employees (
    employee_id NUMBER,
    first_name VARCHAR( 255 ) NOT NULL,
    last_name  VARCHAR( 255 ) NOT NULL,
    email      VARCHAR( 255 ) NOT NULL,
    phone      VARCHAR( 50 ) NOT NULL ,
    hire_date  DATE NOT NULL          ,
    job_title  VARCHAR( 255 ) NOT NULL
  )

INSERT INTO employees VALUES(0,'John','Smith','john@gmail.com','911',TO_DATE('1989-12-09','YYYY-MM-DD'),'Boss')
INSERT INTO employees VALUES(1,'Brian','Church','john@gmail.com','911',TO_DATE('1990-12-09','YYYY-MM-DD'),'Worker')
INSERT INTO employees VALUES(2,'Catherine','Johnson','cat@gmail.com','911',TO_DATE('1991-12-09','YYYY-MM-DD'),'Worker')

SELECT * FROM employees

You can run queries by highlighting selected code and pressing Ctrl + e to run that code. See Keyboard Shortcuts.

Command	Shortcut
Run current statement	Ctrl + q
Run highlighted text	Ctrl + e
Run Line	Ctrl + Enter

This will update your various results panels, result contains your table (excel export etc. supported), charts are generated based on your data and the console summarizes your recent commands

Well Done!

You have now got qStudio querying your database successfully.

We want to make qStudio the best SQL analysis tool. If you have any problems or want additional features, please post on our github repo.