Oracle
The Oracle plugin connects to Oracle Database 12.1 or later in thin mode: nothing else to install, no Instant Client. It downloads the first time you add an Oracle data source. Schemas list in the Database pane, and the console runs SQL and PL/SQL.
Connect
Section titled “Connect”- In Connect by, pick Service name or SID.
- Type the service name or SID in Service.
- Optionally, pick a Role: SYSDBA, SYSOPER or SYSBACKUP.
- For SSL, set SSL mode to Verify CA or Verify full and give the server’s CA file in SSL root certificate. The connection then goes over TCPS.
Or paste oracle://user@host:1521/FREEPDB1 to fill the form in.
Schemas
Section titled “Schemas”Schemas are the tree’s namespaces, yours first and Oracle-maintained ones under System. Packages list
their members as PACKAGE.MEMBER, one row per overload.
ALTER SESSION SET CURRENT_SCHEMA moves the console and its completion to that schema.
Values
Section titled “Values”NUMBERkeeps every digit. ANUMBER(p)column is an integer, andNUMBER(p,s)a decimal padded to its scale.DATEshows its time.CLOBreads as text, and as JSON when it has anIS JSONcheck.BLOBandRAWread as bytes.- Oracle stores
''as NULL, so an empty cell you submit reads back as NULL.
Scripts
Section titled “Scripts”A PL/SQL block ends at a / line and keeps its ;. A plain statement loses its trailing ; before
it is sent.
DBMS_OUTPUT.PUT_LINE lines show in Output after each statement. A procedure that compiles with
errors lists them, with line and column, as warnings.
Transactions
Section titled “Transactions”Oracle commits each DDL statement on its own, so CREATE TABLE in a manual transaction commits what
came before it. The table designer says so before it runs.
Completion
Section titled “Completion”Completion offers every function of the SQL Functions chapter for the server’s version: SYSDATE
without parentheses, EXTRACT(YEAR FROM …) with its argument in bold. After pkg., it offers the
members of DBMS_OUTPUT, DBMS_LOB, DBMS_STATS, UTL_RAW and other supplied packages.
Sessions
Section titled “Sessions”Listing other sessions needs SELECT_CATALOG_ROLE, and cancelling or killing them needs
ALTER SYSTEM. Without them, the tab lists your own session and says what to ask for.
Limits
Section titled “Limits”- Oracle Database versions before 12.1 are not supported.
- SSL has no Require mode, because thin mode always checks the certificate.
See Oracle.
