Oracle and PL/SQL without the Java IDE
PL/SQL packages and procedures with compile errors in the editor, DBMS_OUTPUT, sessions, top SQL and Data Pump, plus Autonomous Database wallets and service levels.
- Oracle Database (including 23ai)
- Oracle Autonomous Database
What you get for Oracle
PL/SQL objects
Packages, procedures, functions, triggers, types, sequences, synonyms, materialized views and 23ai JSON duality views, with source editing and compile errors marked in the editor.
Run it like a DBA
DBMS_OUTPUT capture, bind variable prompts, DBMS_METADATA DDL previews and object wizards. VECTOR and JSON columns display readably.
Performance
Sessions with audited cancel and kill, top SQL, cursor plans and DBMS_SCHEDULER jobs. SQL Monitor and ASH show only for connections you mark as licensed for the Diagnostics and Tuning Packs.
Users and storage
Users, roles, system and object privileges, profiles and quotas; tablespaces and datafiles; Data Pump export and import with progress and log.
Autonomous Database
Import the wallet zip, pick a service level, paste a connect string from the OCI console, and see what ADB doesn't allow before you try it.
And everything every connection gets
Each database keeps its own tools, and shares one workspace with the others.
- Projects with Development, Staging and Production environments, enforced on every write
- Logs & analytics: the server's log, slow operations by shape and live metrics
- An AI assistant that writes and fixes this family's queries, with your own key
- Read-only connections, typed confirmations and a local audit log
- Saved queries as files in a folder you can put in Git
- Notebooks and charts on live results
Features to look at next
Also in relational: PostgreSQL, MySQL and MariaDB, SQL Server.
Your next query deserves a better IDE.
Create a free account, download MotionQL, and paste your Pro key. You'll be querying in under two minutes.