Skip to main content

@sqb/oracle-dialect

SQB's dialect plugin for Oracle Database — teaches @sqb/builder how to render Oracle's SQL syntax, including version-dependent pagination: a rownum-wrapped subquery when dialectVersion is omitted or < 12, and real FETCH FIRST ... ROWS ONLY syntax for dialectVersion >= 12. See Generating SQL per dialect for dialectVersion itself.

No exported API

This package exports nothing. Its entire effect is a side effect of importing it: it constructs an internal OracleSerializer (not exported) and registers it with SerializerRegistry for dialect: 'oracle'.

import '@sqb/oracle-dialect';

@sqb/oracle (the connection adapter) imports this package internally as part of its own entry point, so you don't need to import it yourself when using @sqb/oracle — only when using @sqb/builder standalone (no @sqb/connect/adapter) and you still want .generate({ dialect: 'oracle' }) to render Oracle SQL.

See also