OracleDSL (jOOQ 3.3.4 API)

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

All Methods Static Methods Concrete 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.
`static Field<String>`	`toChar(Field<String> value)` The Oracle-specific `TO_CHAR` function.
`static Field<String>`	`toChar(Field<String> value, Field<String> formatMask)` The Oracle-specific `TO_CHAR` function.
`static Field<String>`	`toChar(Field<String> value, String formatMask)` The Oracle-specific `TO_CHAR` function.
`static Field<String>`	`toChar(String value)` The Oracle-specific `TO_CHAR` function.
`static Field<String>`	`toChar(String value, Field<String> formatMask)` The Oracle-specific `TO_CHAR` function.
`static Field<String>`	`toChar(String value, String formatMask)` The Oracle-specific `TO_CHAR` function.
`static Field<Long>`	`versionsEndscn()` The Oracle-specific `VERSIONS_ENDSCN` pseudo-field.
`static Field<Timestamp>`	`versionsEndtime()` The Oracle-specific `VERSIONS_ENDTIME` pseudo-field.
`static Field<String>`	`versionsOperation()` The Oracle-specific `VERSIONS_OPERATION` pseudo-field.
`static Field<Long>`	`versionsStartscn()` The Oracle-specific `VERSIONS_STARTSCN` pseudo-field.
`static Field<Timestamp>`	`versionsStarttime()` The Oracle-specific `VERSIONS_STARTTIME` pseudo-field.
`static Field<String>`	`versionsXid()` The Oracle-specific `VERSIONS_XID` pseudo-field.

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, cast, cast, cast, castNull, castNull, castNull, ceil, ceil, charLength, charLength, coalesce, coalesce, coerce, coerce, coerce, concat, concat, condition, condition, condition, condition, connectByIsCycle, connectByIsLeaf, connectByRoot, cos, cos, cosh, cosh, cot, cot, coth, coth, count, count, countDistinct, countDistinct, cube, cumeDist, currentDate, currentTime, currentTimestamp, currentUser, date, date, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateDiff, dateDiff, dateDiff, dateDiff, day, day, decode, decode, decode, decode, decode, deg, deg, delete, denseRank, dual, 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, generateSeries, generateSeries, generateSeries, generateSeries, getDataType, greatest, greatest, groupConcat, groupConcat, groupConcatDistinct, grouping, groupingId, groupingSets, groupingSets, groupingSets, hour, hour, inline, inline, inline, inline, inline, inline, inline, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, isnull, isnull, isnull, isnull, keyword, lag, lag, lag, lag, lastValue, lateral, lead, lead, lead, lead, least, least, left, left, left, left, length, length, level, listAgg, listAgg, ln, ln, log, log, lower, lower, lpad, lpad, lpad, lpad, lpad, ltrim, ltrim, max, maxDistinct, md5, md5, median, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mid, mid, 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, orderBy, orderBy, orderBy, param, param, param, param, partitionBy, partitionBy, percentRank, pi, position, position, position, position, power, power, power, power, prior, queryPart, queryPart, queryPart, rad, rad, rand, rank, regrAvgX, regrAvgY, regrCount, regrIntercept, regrR2, regrSlope, regrSXX, regrSXY, regrSYY, repeat, repeat, repeat, repeat, replace, replace, replace, replace, reverse, reverse, right, right, right, right, 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, row, rowNumber, rowsBetweenCurrentRow, rowsBetweenFollowing, rowsBetweenPreceding, rowsBetweenUnboundedFollowing, rowsBetweenUnboundedPreceding, rowsCurrentRow, rowsFollowing, rowsPreceding, rowsUnboundedFollowing, rowsUnboundedPreceding, 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, space, space, sqrt, sqrt, stddevPop, stddevSamp, substring, substring, substring, substring, sum, sumDistinct, sysConnectByPath, table, table, table, table, table, table, table, table, table, tableByName, tan, tan, tanh, tanh, time, time, timestamp, timestamp, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampDiff, timestampDiff, timestampDiff, timestampDiff, trim, trim, trueCondition, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, truncate, two, unnest, unnest, unnest, unnest, update, upper, upper, using, using, 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, 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.