Oracle

https://www.oracle.com/database/

Oracle Database is a multi-model database management system.

Installation

Required packages: oracledb

Connection String

oracle://{username}:{password}@{hostname}:{port}

Default port: 1521

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

Notes

Previously used cx_Oracle, now uses oracledb.

Resources

Official Documentation

Help improve this documentation by editing the engine spec:

Edit oracle.py