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

Constructors

Constructor and Description
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

Methods

Modifier and Type	Method and Description
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, 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, regrAvgX, regrAvgY, regrCount, regrIntercept, regrR2, regrSlope, regrSXX, regrSXY, regrSYY, releaseSavepoint, render, renderContext, renderInlined, renderNamedParams, repeat, repeat, repeat, repeat, replace, replace, replace, replace, resultQuery, resultQuery, resultQuery, rollback, rollback, rollup, round, round, round, round, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, rowNumber, rpad, rpad, rpad, rpad, rpad, rtrim, rtrim, schemaByName, 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, 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

@Support(value=ORACLE)
public static Field<Integer> rownum()

Retrieve the Oracle-specific ROWNUM pseudo-field

rowid

@Support(value=ORACLE)
public static Field<String> rowid()

Retrieve the Oracle-specific ROWID pseudo-field

sysContext

@Support(value=ORACLE)
public static Field<String> sysContext(String namespace,
                                          String parameter)

The Oracle-specific SYS_CONTEXT function

sysContext

@Support(value=ORACLE)
public static Field<String> sysContext(String namespace,
                                          String parameter,
                                          int length)

The Oracle-specific SYS_CONTEXT function

contains

@Support(value=ORACLE)
public static Field<BigDecimal> contains(Field<String> field,
                                            String query)

The Oracle-Text specific CONTAINS function

contains

@Support(value=ORACLE)
public static Field<BigDecimal> contains(Field<String> field,
                                            String query,
                                            int label)

The Oracle-Text specific CONTAINS function

matches

@Support(value=ORACLE)
public static Field<BigDecimal> matches(Field<String> field,
                                           String query)

The Oracle-Text specific MATCHES function

matches

@Support(value=ORACLE)
public static Field<BigDecimal> matches(Field<String> field,
                                           String query,
                                           int label)

The Oracle-Text specific CONTAINS function

catsearch

@Support(value=ORACLE)
public static Field<BigDecimal> catsearch(Field<String> field,
                                             String textQuery,
                                             String structuredQuery)

The Oracle-Text specific CATSEARCH function

score

@Support(value=ORACLE)
public static Field<BigDecimal> score(int label)

The Oracle-Text specific SCORE function

matchScore

@Support(value=ORACLE)
public static Field<BigDecimal> matchScore(int label)

The Oracle-Text specific MATCH_SCORE function