Oracle Database is a multi-model database management system.
Installation
Required packages: oracledb
Connection String
oracle+oracledb://{username}:{password}@{hostname}:{port}Supported Features
JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation
Feature Score: 28/201
Time Grains
Common Time Grains:
SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR
Extended Time Grains:
FIVE_SECONDSTHIRTY_SECONDSFIVE_MINUTESTEN_MINUTESFIFTEEN_MINUTESTHIRTY_MINUTESHALF_HOURSIX_HOURSWEEK_STARTING_SUNDAYWEEK_STARTING_MONDAYWEEK_ENDING_SATURDAYWEEK_ENDING_SUNDAYQUARTER_YEAR
Extended Aggregate Functions
The base aggregates (SUM, COUNT, AVG, MIN, MAX, COUNT DISTINCT) are supported everywhere; these are opt-in per engine.
MEDIANSTDDEV_SAMPVAR_SAMP
Notes
Previously used cx_Oracle, now uses oracledb. Legacy LONG columns are treated as text, not numeric data, so Explore does not select SUM as their default aggregate. On Oracle 11g and older, which reject FETCH FIRST, row limits use ROWNUM. The server version is detected on first use, or can be set under Advanced > Other > Version.
Resources