public class OracleDSL extends DSL
SQLDialect.ORACLE specific DSL.| Modifier and Type | Class and Description |
|---|---|
static class |
OracleDSL.DBMS_AQ
Oracle AQ related features are located here.
|
| Modifier | Constructor and Description |
|---|---|
protected |
OracleDSL()
No instances
|
| 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<Long> |
oraRowscn()
The Oracle-specific
ORA_ROWSCN pseudo-field. |
static Field<String> |
rowid()
The Oracle-specific
ROWID pseudo-field. |
static Field<Integer> |
rownum()
The Oracle-specific
ROWNUM pseudo-field. |
static Field<Long> |
rowscn()
The Oracle-specific
ORA_ROWSCN pseudo-field. |
static Field<Timestamp> |
scnToTimestamp(Field<? extends Number> scn)
The Oracle-specific
SCN_TO_TIMESTAMP function. |
static Field<Timestamp> |
scnToTimestamp(Number scn)
The Oracle-specific
SCN_TO_TIMESTAMP function. |
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<Long> |
timestampToScn(Date timestamp)
The Oracle-specific
TIMESTAMP_TO_SCN function. |
static Field<Long> |
timestampToScn(Field<? extends Date> scn)
The Oracle-specific
TIMESTAMP_TO_SCN function. |
static Field<String> |
toChar(Field<?> value)
The Oracle-specific
TO_CHAR function. |
static Field<String> |
toChar(Field<?> value,
Field<String> formatMask)
The Oracle-specific
TO_CHAR function. |
static Field<String> |
toChar(Field<?> value,
String formatMask)
The Oracle-specific
TO_CHAR function. |
static Field<String> |
toChar(Object value)
The Oracle-specific
TO_CHAR function. |
static Field<String> |
toChar(Object value,
Field<String> formatMask)
The Oracle-specific
TO_CHAR function. |
static Field<String> |
toChar(Object value,
String formatMask)
The Oracle-specific
TO_CHAR function. |
static Field<BigDecimal> |
toNumber(Field<String> value)
The Oracle-specific
TO_NUMBER function. |
static Field<BigDecimal> |
toNumber(Field<String> value,
Field<String> formatMask)
The Oracle-specific
TO_NUMBER function. |
static Field<BigDecimal> |
toNumber(Field<String> value,
String formatMask)
The Oracle-specific
TO_NUMBER function. |
static Field<BigDecimal> |
toNumber(String value)
The Oracle-specific
TO_NUMBER function. |
static Field<BigDecimal> |
toNumber(String value,
Field<String> formatMask)
The Oracle-specific
TO_NUMBER function. |
static Field<BigDecimal> |
toNumber(String value,
String formatMask)
The Oracle-specific
TO_NUMBER 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. |
abs, abs, acos, acos, all, all, all, alterIndex, alterIndex, alterIndex, alterIndexIfExists, alterIndexIfExists, alterIndexIfExists, alterSchema, alterSchema, alterSchema, alterSchemaIfExists, alterSchemaIfExists, alterSchemaIfExists, alterSequence, alterSequence, alterSequence, alterSequenceIfExists, alterSequenceIfExists, alterSequenceIfExists, alterTable, alterTable, alterTable, alterTableIfExists, alterTableIfExists, alterTableIfExists, alterView, alterView, alterView, alterViewIfExists, alterViewIfExists, alterViewIfExists, and, and, and, any, any, any, array, array, array, arrayAgg, arrayAggDistinct, ascii, ascii, asin, asin, asterisk, atan, atan, atan2, atan2, atan2, atan2, avg, avgDistinct, begin, begin, 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, boolAnd, boolAnd, boolOr, boolOr, cast, cast, cast, cast, cast, cast, castNull, castNull, castNull, catalog, ceil, ceil, charLength, charLength, check, choose, choose, choose, choose, choose, choose, choose, coalesce, coalesce, coalesce, coerce, coerce, coerce, coerce, coerce, coerce, collation, collation, collect, collect, collectDistinct, collectDistinct, comment, commentOnColumn, commentOnColumn, commentOnTable, commentOnTable, commentOnTable, commentOnView, commentOnView, commentOnView, concat, concat, concat, concat, condition, condition, condition, condition, condition, condition, condition, condition, condition, condition, condition, connectByIsCycle, connectByIsLeaf, connectByRoot, constraint, constraint, constraint, cos, cos, cosh, cosh, cot, cot, coth, coth, count, count, count, count, countDistinct, countDistinct, countDistinct, countDistinct, createGlobalTemporaryTable, createGlobalTemporaryTable, createGlobalTemporaryTable, createIndex, createIndex, createIndex, createIndex, createIndexIfNotExists, createIndexIfNotExists, createIndexIfNotExists, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createSchema, createSchema, createSchema, createSchemaIfNotExists, createSchemaIfNotExists, createSchemaIfNotExists, createSequence, createSequence, createSequence, createSequenceIfNotExists, createSequenceIfNotExists, createSequenceIfNotExists, createTable, createTable, createTable, createTableIfNotExists, createTableIfNotExists, createTableIfNotExists, createTemporaryTable, createTemporaryTable, createTemporaryTable, createUniqueIndex, createUniqueIndex, createUniqueIndex, createUniqueIndex, createUniqueIndexIfNotExists, createUniqueIndexIfNotExists, createUniqueIndexIfNotExists, createView, createView, createView, createView, createView, createView, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, cube, cube, cumeDist, cumeDist, cumeDist, currentDate, currentLocalDate, currentLocalDateTime, currentLocalTime, currentOffsetDateTime, currentOffsetTime, currentSchema, currentTime, currentTimestamp, currentUser, date, date, date, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateDiff, dateDiff, dateDiff, dateDiff, dateSub, dateSub, dateSub, dateSub, dateSub, dateSub, day, day, day, decode, decode, decode, decode, decode, defaultValue, defaultValue, defaultValue, defaultValue, deg, deg, delete, deleteFrom, denseRank, denseRank, denseRank, dropIndex, dropIndex, dropIndex, dropIndexIfExists, dropIndexIfExists, dropIndexIfExists, dropSchema, dropSchema, dropSchema, dropSchemaIfExists, dropSchemaIfExists, dropSchemaIfExists, dropSequence, dropSequence, dropSequence, dropSequenceIfExists, dropSequenceIfExists, dropSequenceIfExists, dropTable, dropTable, dropTable, dropTableIfExists, dropTableIfExists, dropTableIfExists, dropTemporaryTable, dropTemporaryTable, dropTemporaryTable, dropView, dropView, dropView, dropViewIfExists, dropViewIfExists, dropViewIfExists, dual, e, escape, escape, every, every, exists, 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, fieldByName, fieldByName, fieldByName, firstValue, floor, floor, 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, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, getDataType, grant, grant, grant, greatest, greatest, groupConcat, groupConcat, groupConcatDistinct, groupId, grouping, groupingId, groupingSets, groupingSets, groupingSets, hour, hour, hour, ifnull, ifnull, ifnull, ifnull, iif, iif, iif, iif, 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, 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, link, link, link, list, list, listAgg, listAgg, ln, ln, localDate, localDate, localDate, localDateAdd, localDateAdd, localDateAdd, localDateAdd, localDateAdd, localDateAdd, localDateDiff, localDateDiff, localDateDiff, localDateDiff, localDateSub, localDateSub, localDateSub, localDateSub, localDateSub, localDateSub, localDateTime, localDateTime, localDateTime, localDateTimeAdd, localDateTimeAdd, localDateTimeAdd, localDateTimeAdd, localDateTimeAdd, localDateTimeAdd, localDateTimeDiff, localDateTimeDiff, localDateTimeDiff, localDateTimeDiff, localDateTimeSub, localDateTimeSub, localDateTimeSub, localDateTimeSub, localDateTimeSub, localDateTimeSub, localTime, localTime, localTime, 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, minute, mode, month, month, month, name, name, name, name, noCondition, not, not, not, notExists, now, nthValue, nthValue, ntile, nullif, nullif, nullif, nullif, nullSafe, nullSafe, nullSafe, nullSafeDataType, nvl, nvl, nvl, nvl, nvl2, nvl2, nvl2, nvl2, octetLength, octetLength, offsetDateTime, offsetDateTime, offsetDateTime, offsetTime, offsetTime, offsetTime, one, or, or, or, orderBy, orderBy, orderBy, param, param, param, param, param, param, param, param, param, partitionBy, partitionBy, percentileCont, percentileCont, percentileDisc, percentileDisc, percentRank, percentRank, percentRank, pi, position, position, position, position, position, position, position, position, position, position, position, position, power, power, power, power, primaryKey, primaryKey, primaryKey, prior, privilege, queries, queries, query, query, query, query, queryPart, queryPart, queryPart, quotedName, quotedName, quotedName, rad, rad, rand, rangeBetweenCurrentRow, rangeBetweenFollowing, rangeBetweenPreceding, rangeBetweenUnboundedFollowing, rangeBetweenUnboundedPreceding, rangeCurrentRow, rangeFollowing, rangePreceding, rangeUnboundedFollowing, rangeUnboundedPreceding, rank, rank, rank, ratioToReport, ratioToReport, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, regrAvgX, regrAvgY, regrCount, regrIntercept, regrR2, regrSlope, regrSXX, regrSXY, regrSYY, repeat, repeat, repeat, repeat, replace, replace, replace, replace, resultQuery, resultQuery, resultQuery, resultQuery, reverse, reverse, revoke, revoke, revoke, revokeGrantOptionFor, revokeGrantOptionFor, revokeGrantOptionFor, right, right, right, right, role, role, rollup, 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, 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, rtrim, rtrim, schema, schemaByName, 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, sequenceByName, sequenceByName, sequenceByName, setCatalog, setCatalog, setCatalog, setSchema, setSchema, setSchema, shl, shl, shl, shl, shr, shr, shr, shr, sign, sign, sin, sin, sinh, sinh, space, space, sql, sql, sql, sqrt, sqrt, stddevPop, stddevSamp, substring, substring, substring, substring, sum, sumDistinct, sysConnectByPath, table, table, table, table, table, table, table, table, table, table, table, table, table, table, tableByName, tan, tan, tanh, tanh, time, time, time, timestamp, timestamp, timestamp, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampDiff, timestampDiff, timestampDiff, timestampDiff, timestampSub, timestampSub, timestampSub, timestampSub, timestampSub, timestampSub, toDate, toDate, toDate, toDate, toLocalDate, toLocalDate, toLocalDate, toLocalDate, toLocalDateTime, toLocalDateTime, toLocalDateTime, toLocalDateTime, toTimestamp, toTimestamp, toTimestamp, toTimestamp, translate, translate, trim, trim, trueCondition, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, truncate, truncate, two, unique, unique, unique, unnest, unnest, unnest, unnest, unquotedName, unquotedName, unquotedName, update, upper, upper, user, user, using, using, using, using, using, using, using, using, using, using, using, using, using, using, 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, 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, when, when, when, 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, 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, year, year, year, zero@Support(value=ORACLE) public static Field<Integer> rownum()
ROWNUM pseudo-field.@Support(value=ORACLE) public static Field<String> rowid()
ROWID pseudo-field.@Support(value=ORACLE) public static Field<Long> rowscn()
ORA_ROWSCN pseudo-field.@Support(value=ORACLE) public static Field<Long> oraRowscn()
ORA_ROWSCN pseudo-field.@Support(value=ORACLE) public static Field<Timestamp> scnToTimestamp(Number scn)
SCN_TO_TIMESTAMP function.@Support(value=ORACLE) public static Field<Timestamp> scnToTimestamp(Field<? extends Number> scn)
SCN_TO_TIMESTAMP function.@Support(value=ORACLE) public static Field<Long> timestampToScn(Date timestamp)
TIMESTAMP_TO_SCN function.@Support(value=ORACLE) public static Field<Long> timestampToScn(Field<? extends Date> scn)
TIMESTAMP_TO_SCN function.@Support(value=ORACLE) public static Field<String> sysContext(String namespace, String parameter)
SYS_CONTEXT function.@Support(value=ORACLE) public static Field<String> sysContext(String namespace, String parameter, int length)
SYS_CONTEXT function.@Support(value=ORACLE) public static Field<String> toChar(Object value)
TO_CHAR function.@Support(value=ORACLE) public static Field<String> toChar(Field<?> value)
TO_CHAR function.@Support(value=ORACLE) public static Field<String> toChar(Object value, String formatMask)
TO_CHAR function.@Support(value=ORACLE) public static Field<String> toChar(Object value, Field<String> formatMask)
TO_CHAR function.@Support(value=ORACLE) public static Field<String> toChar(Field<?> value, String formatMask)
TO_CHAR function.@Support(value=ORACLE) public static Field<String> toChar(Field<?> value, Field<String> formatMask)
TO_CHAR function.@Support(value=ORACLE) public static Field<BigDecimal> toNumber(String value)
TO_NUMBER function.@Support(value=ORACLE) public static Field<BigDecimal> toNumber(Field<String> value)
TO_NUMBER function.@Support(value=ORACLE) public static Field<BigDecimal> toNumber(String value, String formatMask)
TO_NUMBER function.@Support(value=ORACLE) public static Field<BigDecimal> toNumber(String value, Field<String> formatMask)
TO_NUMBER function.@Support(value=ORACLE) public static Field<BigDecimal> toNumber(Field<String> value, String formatMask)
TO_NUMBER function.@Support(value=ORACLE) public static Field<BigDecimal> toNumber(Field<String> value, Field<String> formatMask)
TO_NUMBER function.@Support(value=ORACLE) public static Field<Long> versionsStartscn()
VERSIONS_STARTSCN pseudo-field.@Support(value=ORACLE) public static Field<Timestamp> versionsStarttime()
VERSIONS_STARTTIME pseudo-field.@Support(value=ORACLE) public static Field<Long> versionsEndscn()
VERSIONS_ENDSCN pseudo-field.@Support(value=ORACLE) public static Field<Timestamp> versionsEndtime()
VERSIONS_ENDTIME pseudo-field.@Support(value=ORACLE) public static Field<String> versionsXid()
VERSIONS_XID pseudo-field.@Support(value=ORACLE) public static Field<String> versionsOperation()
VERSIONS_OPERATION pseudo-field.@Support(value=ORACLE) public static Field<BigDecimal> contains(Field<String> field, String query)
CONTAINS function.@Support(value=ORACLE) public static Field<BigDecimal> contains(Field<String> field, String query, int label)
CONTAINS function.@Support(value=ORACLE) public static Field<BigDecimal> matches(Field<String> field, String query)
MATCHES function.@Support(value=ORACLE) public static Field<BigDecimal> matches(Field<String> field, String query, int label)
CONTAINS function.@Support(value=ORACLE) public static Field<BigDecimal> catsearch(Field<String> field, String textQuery, String structuredQuery)
CATSEARCH function.@Support(value=ORACLE) public static Field<BigDecimal> score(int label)
SCORE function.@Support(value=ORACLE) public static Field<BigDecimal> matchScore(int label)
MATCH_SCORE function.Copyright © 2019. All rights reserved.