Details

  • Oracle Database is a multi-model database management system produced and marketed by Oracle Corporation.

Connecting & Authenticating

  • When configuring Oracle using DatabaseReference[URL["url"]], "url" is typically of the form "oracle://user:password@host:port/name".
  • In DatabaseReference[assoc], typical elements of assoc include:
  • "Backend"the type of SQL backend used
    "Name"the name of the database
    "Host"the host serving the database
    "Port"the server port through which to access the database
    "Username"the username used to authenticate the database
    "Password"the password used to authenticate the database

Supported Types

  • BFILE, BLOB, RAWByteArray
    DATEDateObject with Instant granularity
    TIMESTAMPDateObject with Instant granularity and time zone support
    NUMBERReal with fixed precision
    INTEGERInteger
    BINARY_DOUBLE, BINARY_FLOAT, FLOATReal
    CHAR, CLOB, LONG, NCLOB, NVARCHAR, NVARCHAR2, ROWID, VARCHAR, VARCHAR2String

Examples

Basic Examples  (1)

Create an Oracle connection using the URL wrapper:

The canonical form of a DatabaseReference for Oracle uses Association:

Introduced in 2020
 (12.1)