org.jooq.util.oracle
Class OracleFactory

java.lang.Object
  org.jooq.impl.Factory
      org.jooq.util.oracle.OracleFactory

All Implemented Interfaces:

Serializable, Configuration, FactoryOperations

public class OracleFactory
extends Factory

A SQLDialect.ORACLE specific factory

Author:

Lukas Eder

See Also:

Serialized Form

Constructor Summary

OracleFactory(Connection connection)
Create a factory with connection

OracleFactory(Connection connection, SchemaMapping mapping)
Deprecated. - 2.0.5 - Use OracleFactory(Connection, Settings) instead

OracleFactory(Connection connection, Settings settings)
Create a factory with connection and a settings configured

Method Summary

static Field<String>	rowid() Retrieve the Oracle-specific ROWID pseudo-field
static Field<Integer>	rownum() Retrieve the Oracle-specific ROWNUM pseudo-field
static Field<String>	sysContext(String namespace, String parameter) The Oracle-specific SYS_CONTEXT function
static Field<String>	sysContext(String namespace, String parameter, int length) The Oracle-specific SYS_CONTEXT function

Methods inherited from class org.jooq.impl.Factory

abs, abs, acos, acos, ascii, ascii, asin, asin, atan, atan, atan2, atan2, atan2, atan2, attach, attach, avg, avgDistinct, batch, batch, batch, bind, bindContext, bitAnd, bitAnd, bitAnd, bitAnd, bitCount, bitCount, bitLength, bitLength, bitNand, bitNand, bitNand, bitNand, bitNor, bitNor, bitNor, bitNor, bitNot, bitNot, bitOr, bitOr, bitOr, bitOr, bitXNor, bitXNor, bitXNor, bitXNor, bitXor, bitXor, bitXor, bitXor, cast, cast, cast, castNull, castNull, castNull, ceil, ceil, charLength, charLength, coalesce, coalesce, concat, concat, condition, condition, connectByIsCycle, connectByIsLeaf, cos, cos, cosh, cosh, cot, cot, coth, coth, count, count, countDistinct, cube, cumeDist, currentDate, currentTime, currentTimestamp, currentUser, currval, dateDiff, dateDiff, dateDiff, dateDiff, day, day, decode, decode, decode, decode, decode, deg, deg, delete, deleteQuery, denseRank, e, escape, escape, execute, execute, executeDelete, executeDelete, executeDeleteOne, executeDeleteOne, executeInsert, executeUpdate, executeUpdate, executeUpdateOne, executeUpdateOne, exists, exp, exp, extract, extract, falseCondition, fetch, fetch, fetch, fetch, fetch, fetchAny, fetchLazy, fetchLazy, fetchMany, fetchMany, fetchOne, fetchOne, fetchOne, fetchOne, field, field, field, field, field, field, field, field, field, firstValue, floor, floor, function, function, getConnection, getData, getData, getDataType, getDialect, getSchemaMapping, getSettings, greatest, greatest, groupConcat, groupConcatDistinct, grouping, groupingId, groupingSets, groupingSets, groupingSets, hour, hour, insertInto, insertInto, insertInto, insertInto, insertQuery, lag, lag, lag, lag, lastID, lastValue, lead, lead, lead, lead, least, least, length, length, level, listAgg, listAgg, literal, literal, literal, ln, ln, loadInto, log, log, lower, lower, lpad, lpad, lpad, lpad, lpad, ltrim, ltrim, max, maxDistinct, median, mergeInto, min, minDistinct, minute, minute, month, month, newRecord, newRecord, newRecord, nextval, notExists, ntile, nullif, nullif, nullif, nullif, nvl, nvl, nvl, nvl, nvl2, nvl2, nvl2, nvl2, octetLength, octetLength, one, param, param, param, param, percentRank, pi, position, position, position, position, power, power, power, power, prior, query, query, rad, rad, rand, rank, render, renderContext, renderInlined, renderNamedParams, repeat, repeat, repeat, repeat, replace, replace, replace, replace, resultQuery, resultQuery, rollup, round, round, round, round, rowNumber, rpad, rpad, rpad, rpad, rpad, rtrim, rtrim, second, second, select, select, selectCount, selectDistinct, selectDistinct, selectFrom, selectOne, selectQuery, selectQuery, selectZero, setConnection, setData, shl, shl, shl, shl, shr, shr, shr, shr, sign, sign, sin, sin, sinh, sinh, sqrt, sqrt, stddevPop, stddevSamp, substring, substring, substring, substring, sum, sumDistinct, sysConnectByPath, table, table, table, table, table, table, table, tan, tan, tanh, tanh, timestampDiff, timestampDiff, timestampDiff, timestampDiff, toString, trim, trim, trueCondition, truncate, two, unnest, unnest, unnest, unnest, update, updateQuery, upper, upper, use, use, val, val, val, val, vals, value, value, value, value, varPop, varSamp, year, year, zero

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

OracleFactory

@Deprecated
public OracleFactory(Connection connection,
                                SchemaMapping mapping)

Deprecated. - 2.0.5 - Use OracleFactory(Connection, Settings) instead

Create a factory with connection and a schema mapping configured

Parameters:

connection - The connection to use with objects created from this factory

mapping - The schema mapping to use with objects created from this factory

OracleFactory

public OracleFactory(Connection connection,
                     Settings settings)

Create a factory with connection and a settings configured

Parameters:

connection - The connection to use with objects created from this factory

settings - The runtime settings to apply to objects created from this factory

OracleFactory

public OracleFactory(Connection connection)

Create a factory with connection

Parameters:

connection - The connection to use with objects created from this factory

Method Detail

rownum

public static Field<Integer> rownum()

Retrieve the Oracle-specific ROWNUM pseudo-field

rowid

public static Field<String> rowid()

Retrieve the Oracle-specific ROWID pseudo-field

sysContext

public static Field<String> sysContext(String namespace,
                                       String parameter)

The Oracle-specific SYS_CONTEXT function

sysContext

public static Field<String> sysContext(String namespace,
                                       String parameter,
                                       int length)

The Oracle-specific SYS_CONTEXT function