This Oracle tester allows you to test Oracle database SQL.You can test Oracle queries (Oracle 18c Express Edition Release 22.214.171.124.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
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".
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.
Click on "Export" to export the results in csv format of the last query executed.
You can share SQL snippet. Click on "Share snippet" to share your Oracle queries.
/!\ Only queries in the editor are shared!
It is not possible to dump. You must export table by table (in CSV format).
Ctrl-space for autocomplete.
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).
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.