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()
Create a connection-less factory Without a connection, this factory cannot execute queries.

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

OracleFactory(DataSource dataSource)
Create a factory with a data source

OracleFactory(DataSource dataSource, Settings settings)
Create a factory with a data source and a settings configured

OracleFactory(Settings settings)
Create a factory with settings configured Without a connection, this factory cannot execute queries.

Method Summary

static Field<BigDecimal>	catsearch(Field<String> field, String textQuery, String structuredQuery) The Oracle-Text specific CATSEARCH function
static Field<BigDecimal>	contains(Field<String> field, String query) The Oracle-Text specific CONTAINS function
static Field<BigDecimal>	contains(Field<String> field, String query, int label) The Oracle-Text specific CONTAINS function
static Field<BigDecimal>	matches(Field<String> field, String query) The Oracle-Text specific MATCHES function
static Field<BigDecimal>	matches(Field<String> field, String query, int label) The Oracle-Text specific CONTAINS function
static Field<BigDecimal>	matchScore(int label) The Oracle-Text specific MATCH_SCORE function
static Field<String>	rowid() Retrieve the Oracle-specific ROWID pseudo-field
static Field<Integer>	rownum() Retrieve the Oracle-specific ROWNUM pseudo-field
static Field<BigDecimal>	score(int label) The Oracle-Text specific SCORE function
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, batchStore, batchStore, 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, commit, concat, concat, condition, condition, condition, connectByIsCycle, connectByIsLeaf, connectByRoot, cos, cos, cosh, cosh, cot, cot, coth, coth, count, count, countDistinct, cube, cumeDist, currentDate, currentTime, currentTimestamp, currentUser, currval, dateAdd, dateAdd, dateDiff, dateDiff, dateDiff, dateDiff, day, day, decode, decode, decode, decode, decode, deg, deg, delete, deleteQuery, denseRank, e, escape, escape, execute, execute, execute, executeDelete, executeDelete, executeDelete, executeDelete, executeDeleteOne, executeDeleteOne, executeInsert, executeInsert, executeUpdate, executeUpdate, executeUpdate, executeUpdate, executeUpdateOne, executeUpdateOne, exists, exp, exp, extract, extract, falseCondition, fetch, fetch, fetch, fetch, fetch, fetch, fetchAny, fetchFromCSV, fetchFromCSV, fetchLazy, fetchLazy, fetchLazy, fetchLazy, fetchMany, fetchMany, fetchMany, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, field, field, field, field, field, field, field, field, field, fieldByName, fieldByName, fieldByName, firstValue, floor, floor, function, function, getAutoCommit, getConnection, getData, getData, getDataSource, getDataType, getDialect, getHoldability, getSchemaMapping, getSettings, getTransactionIsolation, greatest, greatest, groupConcat, groupConcatDistinct, grouping, groupingId, groupingSets, groupingSets, groupingSets, hour, hour, inline, inline, inline, inline, inline, inline, inline, 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, mergeInto, mergeInto, min, minDistinct, minute, minute, month, month, name, newRecord, newRecord, newRecord, nextval, not, notExists, ntile, nullif, nullif, nullif, nullif, nullSafe, nullSafe, nullSafeDataType, 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, query, rad, rad, rand, rank, releaseSavepoint, render, renderContext, renderInlined, renderNamedParams, repeat, repeat, repeat, repeat, replace, replace, replace, replace, resultQuery, resultQuery, resultQuery, rollback, rollback, 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, setAutoCommit, setConnection, setData, setDataSource, setHoldability, setSavepoint, setSavepoint, setTransactionIsolation, 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, tableByName, tan, tan, tanh, tanh, timestampAdd, timestampAdd, timestampDiff, timestampDiff, timestampDiff, timestampDiff, toString, trim, trim, trueCondition, trunc, trunc, trunc, trunc, trunc, 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(DataSource dataSource,
                     Settings settings)

Create a factory with a data source and a settings configured

Parameters:

dataSource - The data source 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

OracleFactory

public OracleFactory(DataSource dataSource)

Create a factory with a data source

Parameters:

dataSource - The data source to use with objects created from this factory

OracleFactory

public OracleFactory(Settings settings)

Create a factory with settings configured

Without a connection, this factory cannot execute queries. Use it to render SQL only.

Parameters:

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

OracleFactory

public OracleFactory()

Create a connection-less factory

Without a connection, this factory cannot execute queries. Use it to render SQL only.

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

contains

public static Field<BigDecimal> contains(Field<String> field,
                                         String query)

The Oracle-Text specific CONTAINS function

contains

public static Field<BigDecimal> contains(Field<String> field,
                                         String query,
                                         int label)

The Oracle-Text specific CONTAINS function

matches

public static Field<BigDecimal> matches(Field<String> field,
                                        String query)

The Oracle-Text specific MATCHES function

matches

public static Field<BigDecimal> matches(Field<String> field,
                                        String query,
                                        int label)

The Oracle-Text specific CONTAINS function

catsearch

public static Field<BigDecimal> catsearch(Field<String> field,
                                          String textQuery,
                                          String structuredQuery)

The Oracle-Text specific CATSEARCH function

score

public static Field<BigDecimal> score(int label)

The Oracle-Text specific SCORE function

matchScore

public static Field<BigDecimal> matchScore(int label)

The Oracle-Text specific MATCH_SCORE function