1. Referensi API
  2. @samveys/oracle

@samveys/oracle

Driver Oracle Database (node-oracledb mode thin)

Versi
1.0.35 Nov 2026
Pasang
pnpm add @samveys/oracle
Dokumentasi
README paket ini

Daftar ini dibaca dari versi 1.0.2; jalankan pnpm sync untuk memperbaruinya.

Import 
import { oracle, oracleColumnSql, ORACLE_SESSION_FORMATS, oracleDialect, oracleDriver } from '@samveys/oracle'

Fungsi (2)

oracle Fungsi

An Oracle connection config: `oracle({ host: '127.0.0.1', serviceName: 'FREEPDB1', user: 'app', password })`.

function oracle(options: OracleOptions): ConnectionConfig<OracleOptions>;

Diekspor dari packages/oracle/src/index.ts

oracleColumnSql Fungsi

Oracle type for a schema-builder column.

function oracleColumnSql(column: ColumnDefinition): string;

Diekspor dari packages/oracle/src/dialect.ts

Nilai (3)

ORACLE_SESSION_FORMATS Nilai

Session formats the driver sets on every connection (`alter session`), so Temporal text binds convert implicitly and date/time columns fetched as text parse back without loss.

const ORACLE_SESSION_FORMATS: {
    readonly NLS_DATE_FORMAT: 'YYYY-MM-DD';
    readonly NLS_TIMESTAMP_FORMAT: 'YYYY-MM-DD"T"HH24:MI:SS.FF6';
    readonly NLS_TIMESTAMP_TZ_FORMAT: 'YYYY-MM-DD"T"HH24:MI:SS.FF6TZH:TZM';
};

Diekspor dari packages/oracle/src/dialect.ts

oracleDialect Nilai

The Oracle dialect. Identifiers are quoted and folded to upper case (`"USERS"`), which is the name an unquoted identifier gets, so raw DDL and builder SQL agree; the driver folds upper-case result labels back to lower case. Pagination is `OFFSET … ROWS FETCH NEXT … ROWS ONLY` (12c+); derived tables take no `as` (ADR 0014).

const oracleDialect: Dialect;

Diekspor dari packages/oracle/src/dialect.ts

oracleDriver Nilai

Tidak ada komentar dokumentasi.

const oracleDriver: DatabaseDriver<OracleOptions>;

Diekspor dari packages/oracle/src/index.ts

Interface (1)

OracleOptions Interface

Tidak ada komentar dokumentasi.

interface OracleOptions {
    readonly host: string;
    readonly port?: number;
    /** Service name, e.g. `FREEPDB1`. */
    readonly serviceName: string;
    readonly user: string;
    readonly password: string;
    readonly pool?: {
        readonly max?: number;
    };
}

Diekspor dari packages/oracle/src/index.ts