Module databases/oracle

Dialect implementation for Oracle databases

See

basedialect

Functions


addSqlLimit (sqlBuf, limit)

Extends the SQL statement passed as argument with a limit restriction

Parameters

Array sqlBuf The SQL statement
Limit limit The limit

addSqlOffset (sqlBuf, offset)

Extends the SQL statement passed as argument with an offset restriction

Parameters

Array sqlBuf The SQL statement
Number offset The offset

addSqlRange (sqlBuf, offset, limit)

Extends the SQL statement passed as argument with a range restriction

Parameters

Array sqlBuf The SQL statement
Number offset The offset
Limit limit The limit

getBooleanValue (value)

Returns the boolean value for the value passed as argument

Parameters

Object value The value

Returns

Boolean The boolean value

getDefaultSchema (conn)

Returns the default schema for the connection passed as argument

Parameters

java.sql.Connection conn The connection to use

Returns

String The name of the default schema

getSqlNextSequenceValue (sequenceName)

Returns the SQL statement for retrieving the next value of a sequence

Parameters

String sequenceName The name of the sequence

Returns

String The SQL statement

hasSequenceSupport ()

Returns true

Returns

Boolean True