Oracle online

 


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

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).

Autocompletion

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).

Oracle compiler online

This tool is an Oracle online compiler, 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

Separator
NULL string
Header
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:
Password
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).

Comments