WOLFRAM

Enable JavaScript to interact with content and submit forms on Wolfram websites. Learn how
Wolfram Language & System Documentation Center
"Oracle"

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, RAW ByteArray
    DATE DateObject with Instant granularity
    TIMESTAMP DateObject with Instant granularity and time zone support
    NUMBER Real with fixed precision
    INTEGER Integer
    BINARY_DOUBLE, BINARY_FLOAT, FLOAT Real
    CHAR, CLOB, LONG, NCLOB, NVARCHAR, NVARCHAR2, ROWID, VARCHAR, VARCHAR2 String

Examples

Basic Examples  (1)

Create an Oracle connection using the URL wrapper:

The canonical form of a DatabaseReference for Oracle uses Association :

History

Introduced in 2020 (12.1)

Top [フレーム]

AltStyle によって変換されたページ (->オリジナル) /