Module org.jooq

Package 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

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static final class	OracleDSL.DBMS_AQ	Oracle AQ related features are located here.

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	OracleDSL()	No instances

Method Summary

Modifier and Type	Method	Description
static @NotNull Field<BigDecimal>	catsearch(Field<String> field, String textQuery, String structuredQuery)	The Oracle-Text specific CATSEARCH function.
static @NotNull Field<BigDecimal>	contains(Field<String> field, String query)	The Oracle-Text specific CONTAINS function.
static @NotNull Field<BigDecimal>	contains(Field<String> field, String query, int label)	The Oracle-Text specific CONTAINS function.
static @NotNull Field<BigDecimal>	matches(Field<String> field, String query)	The Oracle-Text specific MATCHES function.
static @NotNull Field<BigDecimal>	matches(Field<String> field, String query, int label)	The Oracle-Text specific CONTAINS function.
static @NotNull Field<BigDecimal>	matchScore(int label)	The Oracle-Text specific MATCH_SCORE function.
static @NotNull Field<Long>	oraRowscn()	The Oracle-specific ORA_ROWSCN pseudo-field.
static @NotNull Field<String>	rowid()	The Oracle-specific ROWID pseudo-field.
static @NotNull Field<Integer>	rownum()	The Oracle-specific ROWNUM pseudo-field.
static @NotNull Field<Long>	rowscn()	The Oracle-specific ORA_ROWSCN pseudo-field.
static @NotNull Field<Timestamp>	scnToTimestamp(Number scn)	The Oracle-specific SCN_TO_TIMESTAMP function.
static @NotNull Field<Timestamp>	scnToTimestamp(Field<? extends Number> scn)	The Oracle-specific SCN_TO_TIMESTAMP function.
static @NotNull Field<BigDecimal>	score(int label)	The Oracle-Text specific SCORE function.
static @NotNull Field<String>	sysContext(String namespace, String parameter)	The Oracle-specific SYS_CONTEXT function.
static @NotNull Field<String>	sysContext(String namespace, String parameter, int length)	The Oracle-specific SYS_CONTEXT function.
static @NotNull Field<Long>	timestampToScn(Date timestamp)	The Oracle-specific TIMESTAMP_TO_SCN function.
static @NotNull Field<Long>	timestampToScn(Field<? extends Date> scn)	The Oracle-specific TIMESTAMP_TO_SCN function.
static @NotNull Field<String>	toChar(Object value)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#8381] [#10641] - Use DSL.toChar(Field, Field) instead.
static @NotNull Field<String>	toChar(Object value, String formatMask)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#8381] [#10641] - Use DSL.toChar(Field, Field) instead.
static @NotNull Field<String>	toChar(Object value, Field<String> formatMask)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#8381] [#10641] - Use DSL.toChar(Field, Field) instead.
static @NotNull Field<String>	toChar(Field<?> value)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#8381] [#10641] - Use DSL.toChar(Field, Field) instead.
static @NotNull Field<String>	toChar(Field<?> value, String formatMask)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#8381] [#10641] - Use DSL.toChar(Field, Field) instead.
static @NotNull Field<String>	toChar(Field<?> value, Field<String> formatMask)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.14.0 - [#8381] [#10641] - Use DSL.toChar(Field, Field) instead.
static @NotNull Field<BigDecimal>	toNumber(String value)	The Oracle-specific TO_NUMBER function.
static @NotNull Field<BigDecimal>	toNumber(String value, String formatMask)	The Oracle-specific TO_NUMBER function.
static @NotNull Field<BigDecimal>	toNumber(String value, Field<String> formatMask)	The Oracle-specific TO_NUMBER function.
static @NotNull Field<BigDecimal>	toNumber(Field<String> value)	The Oracle-specific TO_NUMBER function.
static @NotNull Field<BigDecimal>	toNumber(Field<String> value, String formatMask)	The Oracle-specific TO_NUMBER function.
static @NotNull Field<BigDecimal>	toNumber(Field<String> value, Field<String> formatMask)	The Oracle-specific TO_NUMBER function.
static @NotNull Field<Long>	versionsEndscn()	The Oracle-specific VERSIONS_ENDSCN pseudo-field.
static @NotNull Field<Timestamp>	versionsEndtime()	The Oracle-specific VERSIONS_ENDTIME pseudo-field.
static @NotNull Field<String>	versionsOperation()	The Oracle-specific VERSIONS_OPERATION pseudo-field.
static @NotNull Field<Long>	versionsStartscn()	The Oracle-specific VERSIONS_STARTSCN pseudo-field.
static @NotNull Field<Timestamp>	versionsStarttime()	The Oracle-specific VERSIONS_STARTTIME pseudo-field.
static @NotNull Field<String>	versionsXid()	The Oracle-specific VERSIONS_XID pseudo-field.

Methods inherited from class org.jooq.impl.DSL

abs, abs, acos, acos, acosh, acosh, acoth, acoth, aggregate, aggregate, aggregate, aggregate, aggregateDistinct, aggregateDistinct, aggregateDistinct, aggregateDistinct, all, all, all, all, alterDatabase, alterDatabase, alterDatabase, alterDatabaseIfExists, alterDatabaseIfExists, alterDatabaseIfExists, alterDomain, alterDomain, alterDomain, alterDomainIfExists, alterDomainIfExists, alterDomainIfExists, alterIndex, alterIndex, alterIndex, alterIndexIfExists, alterIndexIfExists, alterIndexIfExists, alterMaterializedView, alterMaterializedView, alterMaterializedView, alterMaterializedViewIfExists, alterMaterializedViewIfExists, alterMaterializedViewIfExists, alterSchema, alterSchema, alterSchema, alterSchemaIfExists, alterSchemaIfExists, alterSchemaIfExists, alterSequence, alterSequence, alterSequence, alterSequenceIfExists, alterSequenceIfExists, alterSequenceIfExists, alterTable, alterTable, alterTable, alterTableIfExists, alterTableIfExists, alterTableIfExists, alterType, alterType, alterTypeIfExists, alterTypeIfExists, alterView, alterView, alterView, alterView, alterView, alterViewIfExists, alterViewIfExists, alterViewIfExists, and, and, and, any, any, any, any, anyValue, array, array, array, array, arrayAgg, arrayAggDistinct, arrayAllMatch, arrayAllMatch, arrayAllMatch, arrayAllMatch, arrayAnyMatch, arrayAnyMatch, arrayAnyMatch, arrayAnyMatch, arrayAppend, arrayAppend, arrayAppend, arrayAppend, arrayConcat, arrayConcat, arrayConcat, arrayConcat, arrayFilter, arrayFilter, arrayFilter, arrayFilter, arrayGet, arrayGet, arrayMap, arrayMap, arrayMap, arrayMap, arrayNoneMatch, arrayNoneMatch, arrayNoneMatch, arrayNoneMatch, arrayOverlap, arrayOverlap, arrayOverlap, arrayOverlap, arrayPrepend, arrayPrepend, arrayPrepend, arrayPrepend, arrayRemove, arrayRemove, arrayRemove, arrayRemove, arrayReplace, arrayReplace, arrayToString, arrayToString, arrayToString, arrayToString, ascii, ascii, asin, asin, asinh, asinh, asterisk, atan, atan, atan2, atan2, atan2, atan2, atanh, atanh, avg, avgDistinct, begin, begin, binaryBitLength, binaryBitLength, binaryConcat, binaryConcat, binaryConcat, binaryConcat, binaryLength, binaryLength, binaryListAgg, binaryListAgg, binaryListAgg, binaryListAggDistinct, binaryListAggDistinct, binaryListAggDistinct, binaryLtrim, binaryLtrim, binaryLtrim, binaryLtrim, binaryMd5, binaryMd5, binaryOctetLength, binaryOctetLength, binaryOverlay, binaryOverlay, binaryOverlay, binaryOverlay, binaryPosition, binaryPosition, binaryPosition, binaryPosition, binaryPosition, binaryPosition, binaryPosition, binaryPosition, binaryPosition, binaryPosition, binaryPosition, binaryPosition, binaryRtrim, binaryRtrim, binaryRtrim, binaryRtrim, binarySubstring, binarySubstring, binarySubstring, binarySubstring, binarySubstring, binarySubstring, binaryTrim, binaryTrim, binaryTrim, binaryTrim, binToUuid, binToUuid, bitAnd, bitAnd, bitAnd, bitAnd, bitAndAgg, bitCount, bitCount, bitGet, bitGet, bitLength, bitLength, bitNand, bitNand, bitNand, bitNand, bitNandAgg, bitNor, bitNor, bitNor, bitNor, bitNorAgg, bitNot, bitNot, bitOr, bitOr, bitOr, bitOr, bitOrAgg, bitSet, bitSet, bitSet, bitSet, bitSet, bitSet, bitXNor, bitXNor, bitXNor, bitXNor, bitXNorAgg, bitXor, bitXor, bitXor, bitXor, bitXorAgg, boolAnd, boolAnd, boolOr, boolOr, call, call, cardinality, case_, case_, case_, cast, cast, cast, cast, cast, cast, castNull, castNull, castNull, catalog, catalog, cbrt, cbrt, ceil, ceil, century, century, century, characterSet, characterSet, charLength, charLength, check, choose, choose, choose, choose, choose, choose, choose, chr, chr, coalesce, coalesce, coalesce, coerce, coerce, coerce, coerce, coerce, coerce, collation, collation, collect, collect, collectDistinct, collectDistinct, comment, commentOnColumn, commentOnColumn, commentOnColumn, commentOnMaterializedView, commentOnMaterializedView, commentOnMaterializedView, commentOnTable, commentOnTable, commentOnTable, commentOnView, commentOnView, commentOnView, commit, concat, concat, concat, concat, condition, condition, condition, condition, condition, condition, condition, condition, condition, condition, condition, connectByIsCycle, connectByIsLeaf, connectByRoot, constraint, constraint, constraint, continue_, continue_, continueWhen, continueWhen, convert, convert, corr, cos, cos, cosh, cosh, cot, cot, coth, coth, count, count, count, count, countDistinct, countDistinct, countDistinct, countDistinct, covarPop, covarSamp, createDatabase, createDatabase, createDatabase, createDatabaseIfNotExists, createDatabaseIfNotExists, createDatabaseIfNotExists, createDomain, createDomain, createDomain, createDomainIfNotExists, createDomainIfNotExists, createDomainIfNotExists, createFunction, createFunction, createGlobalTemporaryTable, createGlobalTemporaryTable, createGlobalTemporaryTable, createGlobalTemporaryTableIfNotExists, createGlobalTemporaryTableIfNotExists, createGlobalTemporaryTableIfNotExists, createIndex, createIndex, createIndex, createIndex, createIndexIfNotExists, createIndexIfNotExists, createIndexIfNotExists, createIndexIfNotExists, createMaterializedView, createMaterializedView, createMaterializedView, createMaterializedView, createMaterializedView, createMaterializedView, createMaterializedViewIfNotExists, createMaterializedViewIfNotExists, createMaterializedViewIfNotExists, createMaterializedViewIfNotExists, createMaterializedViewIfNotExists, createMaterializedViewIfNotExists, createOrReplaceFunction, createOrReplaceFunction, createOrReplaceMaterializedView, createOrReplaceMaterializedView, createOrReplaceMaterializedView, createOrReplaceMaterializedView, createOrReplaceMaterializedView, createOrReplaceMaterializedView, createOrReplaceProcedure, createOrReplaceProcedure, createOrReplacePublicSynonym, createOrReplacePublicSynonym, createOrReplacePublicSynonym, createOrReplaceSynonym, createOrReplaceSynonym, createOrReplaceSynonym, createOrReplaceTrigger, createOrReplaceTrigger, createOrReplaceTrigger, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createProcedure, createProcedure, createPublicSynonym, createPublicSynonym, createPublicSynonym, createSchema, createSchema, createSchema, createSchemaIfNotExists, createSchemaIfNotExists, createSchemaIfNotExists, createSequence, createSequence, createSequence, createSequenceIfNotExists, createSequenceIfNotExists, createSequenceIfNotExists, createSynonym, createSynonym, createSynonym, createTable, createTable, createTable, createTableIfNotExists, createTableIfNotExists, createTableIfNotExists, createTemporaryTable, createTemporaryTable, createTemporaryTable, createTemporaryTableIfNotExists, createTemporaryTableIfNotExists, createTemporaryTableIfNotExists, createTrigger, createTrigger, createTrigger, createType, createType, createType, createTypeIfNotExists, createTypeIfNotExists, createTypeIfNotExists, createUniqueIndex, createUniqueIndex, createUniqueIndex, createUniqueIndex, createUniqueIndexIfNotExists, createUniqueIndexIfNotExists, createUniqueIndexIfNotExists, createUniqueIndexIfNotExists, createView, createView, createView, createView, createView, createView, createView, createView, createView, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, cube, cube, cumeDist, cumeDist, cumeDist, currentCatalog, currentDate, currentInstant, currentLocalDate, currentLocalDateTime, currentLocalDateTime, currentLocalDateTime, currentLocalTime, currentOffsetDateTime, currentOffsetTime, currentSchema, currentTime, currentTimestamp, currentTimestamp, currentTimestamp, currentUser, date, date, date, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateDiff, dateDiff, dateDiff, dateDiff, dateDiff, dateDiff, dateDiff, dateDiff, dateSub, dateSub, dateSub, dateSub, dateSub, dateSub, dateSub, dateSub, day, day, day, dayOfWeek, dayOfWeek, dayOfWeek, dayOfYear, dayOfYear, dayOfYear, decade, decade, decade, declare, declare, declare, decode, decode, decode, decode, decode, default_, default_, default_, default_, defaultValue, defaultValue, defaultValue, defaultValue, deg, deg, delete, deleteFrom, deleting, denseRank, denseRank, denseRank, digits, digits, domain, domain, domain, domain, domain, domain, dropDatabase, dropDatabase, dropDatabase, dropDatabaseIfExists, dropDatabaseIfExists, dropDatabaseIfExists, dropDomain, dropDomain, dropDomain, dropDomainIfExists, dropDomainIfExists, dropDomainIfExists, dropFunction, dropFunction, dropFunctionIfExists, dropFunctionIfExists, dropIndex, dropIndex, dropIndex, dropIndexIfExists, dropIndexIfExists, dropIndexIfExists, dropMaterializedView, dropMaterializedView, dropMaterializedView, dropMaterializedViewIfExists, dropMaterializedViewIfExists, dropMaterializedViewIfExists, dropProcedure, dropProcedure, dropProcedureIfExists, dropProcedureIfExists, dropPublicSynonym, dropPublicSynonym, dropPublicSynonym, dropPublicSynonymIfExists, dropPublicSynonymIfExists, dropPublicSynonymIfExists, dropSchema, dropSchema, dropSchema, dropSchemaIfExists, dropSchemaIfExists, dropSchemaIfExists, dropSequence, dropSequence, dropSequence, dropSequenceIfExists, dropSequenceIfExists, dropSequenceIfExists, dropSynonym, dropSynonym, dropSynonym, dropSynonymIfExists, dropSynonymIfExists, dropSynonymIfExists, dropTable, dropTable, dropTable, dropTableIfExists, dropTableIfExists, dropTableIfExists, dropTemporaryTable, dropTemporaryTable, dropTemporaryTable, dropTemporaryTableIfExists, dropTemporaryTableIfExists, dropTemporaryTableIfExists, dropTrigger, dropTrigger, dropTrigger, dropTriggerIfExists, dropTriggerIfExists, dropTriggerIfExists, dropType, dropType, dropType, dropType, dropType, dropType, dropType, dropTypeIfExists, dropTypeIfExists, dropTypeIfExists, dropTypeIfExists, dropTypeIfExists, dropTypeIfExists, dropTypeIfExists, dropView, dropView, dropView, dropViewIfExists, dropViewIfExists, dropViewIfExists, dual, e, emptyGroupingSet, epoch, epoch, epoch, escape, escape, every, every, excluded, execute, execute, execute, exists, exit, exit, exitWhen, exitWhen, exp, exp, extract, extract, extract, falseCondition, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, finalTable, finalTable, finalTable, firstValue, floor, floor, for_, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, function, function, function, function, function, function, function, function, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, getDataType, goto_, grant, grant, grant, greatest, greatest, groupConcat, groupConcat, groupConcatDistinct, groupId, grouping, groupingId, groupingSets, groupingSets, groupingSets, groupsBetweenCurrentRow, groupsBetweenFollowing, groupsBetweenPreceding, groupsBetweenUnboundedFollowing, groupsBetweenUnboundedPreceding, groupsCurrentRow, groupsFollowing, groupsPreceding, groupsUnboundedFollowing, groupsUnboundedPreceding, hour, hour, hour, if_, if_, if_, if_, if_, ifnull, ifnull, ifnull, ifnull, iif, iif, iif, iif, in, in, index, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inlined, inlined, inlined, inlined, inOut, inOut, insert, insert, inserting, 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, instant, instant, instant, isnull, isnull, isnull, isnull, isoDayOfWeek, isoDayOfWeek, isoDayOfWeek, jsonArray, jsonArray, jsonArrayAgg, jsonArrayAggDistinct, jsonArrayLength, jsonArrayLength, jsonbArray, jsonbArray, jsonbArrayAgg, jsonbArrayAggDistinct, jsonbArrayLength, jsonbArrayLength, jsonbExists, jsonbExists, jsonbGetAttribute, jsonbGetAttribute, jsonbGetAttribute, jsonbGetAttribute, jsonbGetAttributeAsText, jsonbGetAttributeAsText, jsonbGetAttributeAsText, jsonbGetAttributeAsText, jsonbGetElement, jsonbGetElement, jsonbGetElement, jsonbGetElement, jsonbGetElementAsText, jsonbGetElementAsText, jsonbGetElementAsText, jsonbGetElementAsText, jsonbInsert, jsonbInsert, jsonbInsert, jsonbInsert, jsonbKeyExists, jsonbKeyExists, jsonbKeyExists, jsonbKeyExists, jsonbKeys, jsonbKeys, jsonbObject, jsonbObject, jsonbObject, jsonbObject, jsonbObject, jsonbObject, jsonbObject, jsonbObjectAgg, jsonbObjectAgg, jsonbObjectAgg, jsonbObjectAgg, jsonbRemove, jsonbRemove, jsonbReplace, jsonbReplace, jsonbReplace, jsonbReplace, jsonbSet, jsonbSet, jsonbSet, jsonbSet, jsonbTable, jsonbTable, jsonbValue, jsonbValue, jsonEntry, jsonEntry, jsonEntry, jsonEntry, jsonEntry, jsonEntry, jsonEntry, jsonExists, jsonExists, jsonGetAttribute, jsonGetAttribute, jsonGetAttribute, jsonGetAttribute, jsonGetAttributeAsText, jsonGetAttributeAsText, jsonGetAttributeAsText, jsonGetAttributeAsText, jsonGetElement, jsonGetElement, jsonGetElement, jsonGetElement, jsonGetElementAsText, jsonGetElementAsText, jsonGetElementAsText, jsonGetElementAsText, jsonInsert, jsonInsert, jsonInsert, jsonInsert, jsonKeyExists, jsonKeyExists, jsonKeyExists, jsonKeyExists, jsonKeys, jsonKeys, jsonObject, jsonObject, jsonObject, jsonObject, jsonObject, jsonObject, jsonObject, jsonObjectAgg, jsonObjectAgg, jsonObjectAgg, jsonObjectAgg, jsonRemove, jsonRemove, jsonReplace, jsonReplace, jsonReplace, jsonReplace, jsonSet, jsonSet, jsonSet, jsonSet, jsonTable, jsonTable, jsonValue, jsonValue, key, key, keyword, label, label, lag, lag, lag, lag, lag, lag, lag, lambda, lastValue, lateral, lead, lead, lead, lead, lead, lead, lead, least, least, left, left, left, left, length, length, level, link, link, link, list, list, listAgg, listAgg, listAgg, listAggDistinct, listAggDistinct, listAggDistinct, ln, ln, localDate, localDate, localDate, localDateAdd, localDateAdd, localDateAdd, localDateAdd, localDateAdd, localDateAdd, localDateAdd, localDateAdd, localDateDiff, localDateDiff, localDateDiff, localDateDiff, localDateDiff, localDateDiff, localDateDiff, localDateDiff, localDateSub, localDateSub, localDateSub, localDateSub, localDateSub, localDateSub, localDateTime, localDateTime, localDateTime, localDateTimeAdd, localDateTimeAdd, localDateTimeAdd, localDateTimeAdd, localDateTimeAdd, localDateTimeAdd, localDateTimeAdd, localDateTimeAdd, localDateTimeDiff, localDateTimeDiff, localDateTimeDiff, localDateTimeDiff, localDateTimeDiff, localDateTimeDiff, localDateTimeDiff, localDateTimeDiff, localDateTimeSub, localDateTimeSub, localDateTimeSub, localDateTimeSub, localDateTimeSub, localDateTimeSub, localTime, localTime, localTime, log, log, log, log, log10, log10, loop, loop, lower, lower, lpad, lpad, lpad, lpad, lpad, lpad, lpad, ltrim, ltrim, ltrim, ltrim, ltrim, ltrim, max, maxBy, 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, microsecond, microsecond, microsecond, mid, mid, mid, mid, mid, mid, millennium, millennium, millennium, millisecond, millisecond, millisecond, min, minBy, minDistinct, minus, minute, minute, minute, mode, mode, month, month, month, multiset, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAgg, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, multisetAggDistinct, name, name, name, name, neg, newTable, newTable, newTable, noCondition, noField, noField, noField, noField, not, not, noTable, notExists, notUnique, now, now, nthValue, nthValue, ntile, ntile, nullCondition, nullif, nullif, nullif, nullif, nullSafe, nullSafe, nullSafe, nullSafe, nullSafeDataType, nullSafeList, nullSafeList, nvl, nvl, nvl, nvl, nvl2, nvl2, nvl2, nvl2, octetLength, octetLength, offsetDateTime, offsetDateTime, offsetDateTime, offsetTime, offsetTime, offsetTime, oldTable, oldTable, oldTable, one, or, or, or, orderBy, orderBy, orderBy, out, out, overlay, overlay, overlay, overlay, param, param, param, param, param, param, param, param, param, partitionBy, partitionBy, percentileCont, percentileCont, percentileDisc, percentileDisc, percentRank, percentRank, percentRank, period, period, period, pi, position, position, position, position, position, position, position, position, position, position, position, position, power, power, power, power, primaryKey, primaryKey, primaryKey, primaryKey, prior, privilege, product, productDistinct, quarter, quarter, quarter, queries, queries, query, query, query, query, quotedName, quotedName, quotedName, rad, rad, rand, rangeBetweenCurrentRow, rangeBetweenFollowing, rangeBetweenPreceding, rangeBetweenUnboundedFollowing, rangeBetweenUnboundedPreceding, rangeCurrentRow, rangeFollowing, rangePreceding, rangeUnboundedFollowing, rangeUnboundedPreceding, rank, rank, rank, ratioToReport, ratioToReport, raw, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, regexpReplaceAll, regexpReplaceAll, regexpReplaceFirst, regexpReplaceFirst, regrAvgX, regrAvgY, regrCount, regrIntercept, regrR2, regrSlope, regrSXX, regrSXY, regrSYY, releaseSavepoint, releaseSavepoint, repeat, repeat, repeat, repeat, repeat, repeat, replace, replace, replace, replace, replace, replace, resultQuery, resultQuery, resultQuery, resultQuery, return_, return_, return_, reverse, reverse, revoke, revoke, revoke, revokeGrantOptionFor, revokeGrantOptionFor, revokeGrantOptionFor, right, right, right, right, role, role, rollback, rollup, rollup, root, root, root, root, round, round, 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, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowNumber, rowsBetweenCurrentRow, rowsBetweenFollowing, rowsBetweenPreceding, rowsBetweenUnboundedFollowing, rowsBetweenUnboundedPreceding, rowsCurrentRow, rowsFollowing, rowsFrom, rowsPreceding, rowsUnboundedFollowing, rowsUnboundedPreceding, rpad, rpad, rpad, rpad, rpad, rpad, rpad, rtrim, rtrim, rtrim, rtrim, rtrim, rtrim, savepoint, savepoint, schema, schema, second, 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, selectFrom, selectFrom, selectFrom, selectFrom, selectFrom, selectOne, selectZero, sequence, sequence, sequence, sequence, sequence, sequence, set, set, setCatalog, setCatalog, setCatalog, setLocal, setLocal, setSchema, setSchema, setSchema, shl, shl, shl, shl, shr, shr, shr, shr, sign, sign, signalSQLState, signalSQLState, sin, sin, sinh, sinh, space, space, splitPart, splitPart, splitPart, splitPart, sql, sql, sql, sqrt, sqrt, square, square, stArea, stArea, startTransaction, stAsBinary, stAsBinary, stAsText, stAsText, statement, statement, statement, statement, statements, statements, stBoundary, stBoundary, stCentroid, stCentroid, stContains, stContains, stContains, stContains, stCoveredBy, stCoveredBy, stCoveredBy, stCoveredBy, stCovers, stCovers, stCovers, stCovers, stCrosses, stCrosses, stCrosses, stCrosses, stddevPop, stddevSamp, stDifference, stDifference, stDifference, stDifference, stDimension, stDimension, stDisjoint, stDisjoint, stDisjoint, stDisjoint, stDistance, stDistance, stDistance, stDistance, stEndPoint, stEndPoint, stEquals, stEquals, stEquals, stEquals, stExteriorRing, stExteriorRing, stGeometryN, stGeometryN, stGeometryN, stGeometryN, stGeometryType, stGeometryType, stGeomFromText, stGeomFromText, stGeomFromText, stGeomFromText, stGeomFromText, stGeomFromText, stGeomFromWKB, stGeomFromWKB, stGeomFromWKB, stGeomFromWKB, stGeomFromWKB, stGeomFromWKB, stInteriorRingN, stInteriorRingN, stInteriorRingN, stInteriorRingN, stIntersection, stIntersection, stIntersection, stIntersection, stIntersects, stIntersects, stIntersects, stIntersects, stIsClosed, stIsClosed, stIsEmpty, stIsEmpty, stIsRing, stIsRing, stIsSimple, stIsSimple, stIsValid, stIsValid, stLength, stLength, stNumGeometries, stNumGeometries, stNumInteriorRings, stNumInteriorRings, stNumPoints, stNumPoints, stOverlaps, stOverlaps, stOverlaps, stOverlaps, stPerimeter, stPerimeter, stPointN, stPointN, stPointN, stPointN, stringAgg, stringAgg, stringAgg, stringAggDistinct, stringAggDistinct, stringAggDistinct, stringToArray, stringToArray, stringToArray, stringToArray, stSrid, stSrid, stStartPoint, stStartPoint, stTouches, stTouches, stTouches, stTouches, stTransform, stTransform, stTransform, stTransform, stUnion, stUnion, stUnion, stUnion, stWithin, stWithin, stWithin, stWithin, stX, stX, stXMax, stXMax, stXMin, stXMin, stY, stY, stYMax, stYMax, stYMin, stYMin, stZ, stZ, stZMax, stZMax, stZMin, stZMin, substring, substring, substring, substring, substring, substring, substringIndex, substringIndex, substringIndex, substringIndex, sum, sumDistinct, synonym, synonym, sysConnectByPath, systemName, systemName, systemName, systemTime, systemTime, systemTime, table, table, table, table, table, table, table, table, table, table, table, table, table, table, tan, tan, tanh, tanh, tau, time, time, time, timestamp, timestamp, timestamp, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampDiff, timestampDiff, timestampDiff, timestampDiff, timestampDiff, timestampDiff, timestampDiff, timestampDiff, timestampSub, timestampSub, timestampSub, timestampSub, timestampSub, timestampSub, timezone, timezone, timezone, timezoneHour, timezoneHour, timezoneHour, timezoneMinute, timezoneMinute, timezoneMinute, toDate, toDate, toDate, toDate, toHex, toHex, toLocalDate, toLocalDate, toLocalDate, toLocalDate, toLocalDateTime, toLocalDateTime, toLocalDateTime, toLocalDateTime, toTimestamp, toTimestamp, toTimestamp, toTimestamp, translate, translate, translate, translate, trigger, trigger, trim, trim, trim, trim, trim, trim, trueCondition, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, truncate, truncate, truncate, truncate, truncate, truncate, truncate, truncateTable, truncateTable, truncateTable, truncateTable, truncateTable, truncateTable, truncateTable, tryCast, tryCast, two, type, type, type, type, unique, unique, unique, unique, unique, unnest, unnest, unnest, unnest, unquotedName, unquotedName, unquotedName, update, updating, upper, upper, user, user, using, using, using, using, using, using, using, using, using, using, using, using, using, using, using, using, using, using, using, using, uuid, uuidToBin, uuidToBin, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, 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, var, var, variable, variable, varPop, varSamp, week, week, week, when, when, when, when, when, when, while_, widthBucket, widthBucket, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, xmlagg, xmlattributes, xmlattributes, xmlcomment, xmlcomment, xmlconcat, xmlconcat, xmldocument, xmlelement, xmlelement, xmlelement, xmlelement, xmlelement, xmlelement, xmlelement, xmlelement, xmlexists, xmlexists, xmlforest, xmlforest, xmlparseContent, xmlparseContent, xmlparseDocument, xmlparseDocument, xmlpi, xmlpi, xmlpi, xmlpi, xmlquery, xmlquery, xmlserializeContent, xmlserializeContent, xmlserializeDocument, xmlserializeDocument, xmltable, xmltable, xor, xor, xor, year, year, year, zero

Methods inherited from class java.lang.Object

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

Constructor Details

OracleDSL

protected OracleDSL()

No instances

Method Details

rownum

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

The Oracle-specific ROWNUM pseudo-field.

rowid

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

The Oracle-specific ROWID pseudo-field.

rowscn

@NotNull
@Support(ORACLE)
public static @NotNull Field<Long> rowscn()

The Oracle-specific ORA_ROWSCN pseudo-field.

oraRowscn

@NotNull
@Support(ORACLE)
public static @NotNull Field<Long> oraRowscn()

The Oracle-specific ORA_ROWSCN pseudo-field.

scnToTimestamp

@NotNull
@Support(ORACLE)
public static @NotNull Field<Timestamp> scnToTimestamp(Number scn)

The Oracle-specific SCN_TO_TIMESTAMP function.

scnToTimestamp

@NotNull
@Support(ORACLE)
public static @NotNull Field<Timestamp> scnToTimestamp(Field<? extends Number> scn)

The Oracle-specific SCN_TO_TIMESTAMP function.

timestampToScn

@NotNull
@Support(ORACLE)
public static @NotNull Field<Long> timestampToScn(Date timestamp)

The Oracle-specific TIMESTAMP_TO_SCN function.

timestampToScn

@NotNull
@Support(ORACLE)
public static @NotNull Field<Long> timestampToScn(Field<? extends Date> scn)

The Oracle-specific TIMESTAMP_TO_SCN function.

sysContext

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

The Oracle-specific SYS_CONTEXT function.

sysContext

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

The Oracle-specific SYS_CONTEXT function.

toChar

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@Support(ORACLE)
public static @NotNull Field<String> toChar(Object value)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#8381] [#10641] - Use DSL.toChar(Field, Field) instead.

The Oracle-specific TO_CHAR function.

toChar

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@Support(ORACLE)
public static @NotNull Field<String> toChar(Field<?> value)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#8381] [#10641] - Use DSL.toChar(Field, Field) instead.

The Oracle-specific TO_CHAR function.

toChar

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@Support(ORACLE)
public static @NotNull Field<String> toChar(Object value,
 String formatMask)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#8381] [#10641] - Use DSL.toChar(Field, Field) instead.

The Oracle-specific TO_CHAR function.

toChar

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@Support(ORACLE)
public static @NotNull Field<String> toChar(Object value,
 Field<String> formatMask)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#8381] [#10641] - Use DSL.toChar(Field, Field) instead.

The Oracle-specific TO_CHAR function.

toChar

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@Support(ORACLE)
public static @NotNull Field<String> toChar(Field<?> value,
 String formatMask)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#8381] [#10641] - Use DSL.toChar(Field, Field) instead.

The Oracle-specific TO_CHAR function.

toChar

@Deprecated(forRemoval=true,
            since="3.14")
@NotNull
@Support(ORACLE)
public static @NotNull Field<String> toChar(Field<?> value,
 Field<String> formatMask)

Deprecated, for removal: This API element is subject to removal in a future version.

- 3.14.0 - [#8381] [#10641] - Use DSL.toChar(Field, Field) instead.

The Oracle-specific TO_CHAR function.

toNumber

@NotNull
@Support(ORACLE)
public static @NotNull Field<BigDecimal> toNumber(String value)

The Oracle-specific TO_NUMBER function.

toNumber

@NotNull
@Support(ORACLE)
public static @NotNull Field<BigDecimal> toNumber(Field<String> value)

The Oracle-specific TO_NUMBER function.

toNumber

@NotNull
@Support(ORACLE)
public static @NotNull Field<BigDecimal> toNumber(String value,
 String formatMask)

The Oracle-specific TO_NUMBER function.

toNumber

@NotNull
@Support(ORACLE)
public static @NotNull Field<BigDecimal> toNumber(String value,
 Field<String> formatMask)

The Oracle-specific TO_NUMBER function.

toNumber

@NotNull
@Support(ORACLE)
public static @NotNull Field<BigDecimal> toNumber(Field<String> value,
 String formatMask)

The Oracle-specific TO_NUMBER function.

toNumber

@NotNull
@Support(ORACLE)
public static @NotNull Field<BigDecimal> toNumber(Field<String> value,
 Field<String> formatMask)

The Oracle-specific TO_NUMBER function.

versionsStartscn

@NotNull
@Support(ORACLE)
public static @NotNull Field<Long> versionsStartscn()

The Oracle-specific VERSIONS_STARTSCN pseudo-field.

versionsStarttime

@NotNull
@Support(ORACLE)
public static @NotNull Field<Timestamp> versionsStarttime()

The Oracle-specific VERSIONS_STARTTIME pseudo-field.

versionsEndscn

@NotNull
@Support(ORACLE)
public static @NotNull Field<Long> versionsEndscn()

The Oracle-specific VERSIONS_ENDSCN pseudo-field.

versionsEndtime

@NotNull
@Support(ORACLE)
public static @NotNull Field<Timestamp> versionsEndtime()

The Oracle-specific VERSIONS_ENDTIME pseudo-field.

versionsXid

@NotNull
@Support(ORACLE)
public static @NotNull Field<String> versionsXid()

The Oracle-specific VERSIONS_XID pseudo-field.

versionsOperation

@NotNull
@Support(ORACLE)
public static @NotNull Field<String> versionsOperation()

The Oracle-specific VERSIONS_OPERATION pseudo-field.

contains

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

The Oracle-Text specific CONTAINS function.

contains

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

The Oracle-Text specific CONTAINS function.

matches

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

The Oracle-Text specific MATCHES function.

matches

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

The Oracle-Text specific CONTAINS function.

catsearch

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

The Oracle-Text specific CATSEARCH function.

score

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

The Oracle-Text specific SCORE function.

matchScore

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

The Oracle-Text specific MATCH_SCORE function.