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