Oracle online


This Oracle tester allows you to test Oracle database SQL.You can test Oracle queries (Oracle 18c Express Edition Release

This sandbox allows you to test SQL queries specific to the Oracle database. This allows you to experiment without having to install any software on your computer.

This playground has functional limitations, you can not create user, schema, ... basically you can not test everything related to maintenance.

/!\ Data is not persistent over time, the data (tables, ...) are removed after approximately 30 minutes of inactivity.

/!\ Transactions are not managed (autocommit).

License of Oracle: Oracle License

How to test Oracle query online?

Enter your SQL query in the editor, finally click on "Run" to execute it. The query result will be displayed below the editor .

Only one query can be executed at a time! You can also run only one query entered in the editor by selecting it before clicking on "Run".

Code editor

The sql queries entered in the editor are saved so that you will find them during your next visits.
Warning, this is a local backup in your browser, it can be deleted at any time.

How to export the results ?

Click on "Export" to export the results in csv format of the last query executed.

How to share Oracle SQL snippet ?

You can share SQL snippet. Click on "Share snippet" to share your Oracle queries.
/!\ Only queries in the editor are shared!

How to dump Oracle database ?

It is not possible to dump. You must export table by table (in CSV format).


Ctrl-space for autocomplete.

About Oracle Express

Oracle Express Edition is a free Oracle Database. Oracle has offered a free version of their databases since 2005.

This edition is really useful for developers, dbas, teachers, students, ...It allows everyone to start discovering oracle databases, and that for free.You can get an idea of Oracle databases before making a possible purchase.

Oracle Database Express Edition can be use on production environment, it does not restrict in which environment it can be deployed! But it does not receive any patches, including security patches.Some features are not included in this version (See the online documentation for more details).

online oracle compiler

This tool is an Oracle online compiler, that allows developers to write, compile, and execute Oracle SQL code without the need for local installations of Oracle software.It allows you to check oracle queries directly in your browser.This allows you to quickly test your queries in Oracle.

If you have problems with oracle specific sql queries, this tool allows you to share your requests for help on the forums.

The data is persistent for about thirty minutes (Time varies according to server resources).

/!\ Your data pass through the network, avoid playing with production data (password, personal data, ...).

This tools uses oracledb library.

Export results to CSV

NULL string
Save and Share SQL snippet
Save SQL code in order to share it.
Your database will not be backed up, this only saves the editor code!
Be careful, the data will be accessible to everyone, please do not save sensitive data.
Save SQL snippet
Your SQL snippet has been permanently saved and you (or anybody) can access with this link:
Choice a password to modify/delete this SQL snippet later Enter password to modify this SQL snippet.Enter password to delete this SQL snippet.Enter the new password for the fork.
You can report a bug or give feedback by adding a comment (below) or by clicking "Contact me" link (at the top right hand corner of the page).