org.jooq.util.oracle

Class OracleDSL

java.lang.Object

org.jooq.impl.DSL

org.jooq.util.oracle.OracleDSL

public class OracleDSL
extends DSL

The SQLDialect.ORACLE specific DSL.

Author:

Lukas Eder

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.DSL

abs, abs, acos, acos, all, all, all, any, any, any, ascii, ascii, asin, asin, atan, atan, atan2, atan2, atan2, atan2, avg, avgDistinct, 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, condition, connectByIsCycle, connectByIsLeaf, connectByRoot, cos, cos, cosh, cosh, cot, cot, coth, coth, count, count, countDistinct, countDistinct, cube, cumeDist, currentDate, currentTime, currentTimestamp, currentUser, dateAdd, dateAdd, dateDiff, dateDiff, dateDiff, dateDiff, day, day, decode, decode, decode, decode, decode, deg, deg, denseRank, e, escape, escape, exists, exp, exp, extract, extract, falseCondition, field, field, field, field, field, field, field, field, field, field, fieldByName, fieldByName, fieldByName, firstValue, floor, floor, function, function, function, function, getDataType, greatest, greatest, groupConcat, groupConcatDistinct, grouping, groupingId, groupingSets, groupingSets, groupingSets, hour, hour, inline, inline, inline, inline, inline, inline, inline, lag, lag, lag, lag, lastValue, lead, lead, lead, lead, least, least, length, length, level, listAgg, listAgg, ln, ln, log, log, lower, lower, lpad, lpad, lpad, lpad, lpad, ltrim, ltrim, max, maxDistinct, md5, md5, median, min, minDistinct, minute, minute, month, month, name, 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, rad, rad, rand, rank, regrAvgX, regrAvgY, regrCount, regrIntercept, regrR2, regrSlope, regrSXX, regrSXY, regrSYY, repeat, repeat, repeat, repeat, replace, replace, replace, replace, rollup, round, round, round, round, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, 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, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, selectCount, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectFrom, selectOne, selectZero, 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, trim, trim, trueCondition, trunc, trunc, trunc, trunc, trunc, two, unnest, unnest, unnest, unnest, upper, upper, using, using, using, using, using, using, using, using, using, val, val, val, val, value, value, value, value, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, varPop, varSamp, year, year, zero

Methods inherited from class java.lang.Object

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

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