MotionQL
Oracle

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
Oracle SQL and PL/SQL

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.

Same app, same habits

And everything every connection gets

Each database keeps its own tools, and shares one workspace with the others.

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.