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 and Type | Method and Description |
|---|---|
static Field<java.math.BigDecimal> |
catsearch(Field<java.lang.String> field,
java.lang.String textQuery,
java.lang.String structuredQuery)
The Oracle-Text specific
CATSEARCH function. |
static Field<java.math.BigDecimal> |
contains(Field<java.lang.String> field,
java.lang.String query)
The Oracle-Text specific
CONTAINS function. |
static Field<java.math.BigDecimal> |
contains(Field<java.lang.String> field,
java.lang.String query,
int label)
The Oracle-Text specific
CONTAINS function. |
static Field<java.math.BigDecimal> |
matches(Field<java.lang.String> field,
java.lang.String query)
The Oracle-Text specific
MATCHES function. |
static Field<java.math.BigDecimal> |
matches(Field<java.lang.String> field,
java.lang.String query,
int label)
The Oracle-Text specific
CONTAINS function. |
static Field<java.math.BigDecimal> |
matchScore(int label)
The Oracle-Text specific
MATCH_SCORE function. |
static Field<java.lang.Long> |
oraRowscn()
The Oracle-specific
ORA_ROWSCN pseudo-field. |
static Field<java.lang.String> |
rowid()
The Oracle-specific
ROWID pseudo-field. |
static Field<java.lang.Integer> |
rownum()
The Oracle-specific
ROWNUM pseudo-field. |
static Field<java.lang.Long> |
rowscn()
The Oracle-specific
ORA_ROWSCN pseudo-field. |
static Field<java.sql.Timestamp> |
scnToTimestamp(Field<? extends java.lang.Number> scn)
The Oracle-specific
SCN_TO_TIMESTAMP function. |
static Field<java.sql.Timestamp> |
scnToTimestamp(java.lang.Number scn)
The Oracle-specific
SCN_TO_TIMESTAMP function. |
static Field<java.math.BigDecimal> |
score(int label)
The Oracle-Text specific
SCORE function. |
static Field<java.lang.String> |
sysContext(java.lang.String namespace,
java.lang.String parameter)
The Oracle-specific
SYS_CONTEXT function. |
static Field<java.lang.String> |
sysContext(java.lang.String namespace,
java.lang.String parameter,
int length)
The Oracle-specific
SYS_CONTEXT function. |
static Field<java.lang.Long> |
timestampToScn(java.util.Date timestamp)
The Oracle-specific
TIMESTAMP_TO_SCN function. |
static Field<java.lang.Long> |
timestampToScn(Field<? extends java.util.Date> scn)
The Oracle-specific
TIMESTAMP_TO_SCN function. |
static Field<java.lang.String> |
toChar(Field<?> value)
The Oracle-specific
TO_CHAR function. |
static Field<java.lang.String> |
toChar(Field<?> value,
Field<java.lang.String> formatMask)
The Oracle-specific
TO_CHAR function. |
static Field<java.lang.String> |
toChar(Field<?> value,
java.lang.String formatMask)
The Oracle-specific
TO_CHAR function. |
static Field<java.lang.String> |
toChar(java.lang.Object value)
The Oracle-specific
TO_CHAR function. |
static Field<java.lang.String> |
toChar(java.lang.Object value,
Field<java.lang.String> formatMask)
The Oracle-specific
TO_CHAR function. |
static Field<java.lang.String> |
toChar(java.lang.Object value,
java.lang.String formatMask)
The Oracle-specific
TO_CHAR function. |
static Field<java.math.BigDecimal> |
toNumber(Field<java.lang.String> value)
The Oracle-specific
TO_NUMBER function. |
static Field<java.math.BigDecimal> |
toNumber(Field<java.lang.String> value,
Field<java.lang.String> formatMask)
The Oracle-specific
TO_NUMBER function. |
static Field<java.math.BigDecimal> |
toNumber(Field<java.lang.String> value,
java.lang.String formatMask)
The Oracle-specific
TO_NUMBER function. |
static Field<java.math.BigDecimal> |
toNumber(java.lang.String value)
The Oracle-specific
TO_NUMBER function. |
static Field<java.math.BigDecimal> |
toNumber(java.lang.String value,
Field<java.lang.String> formatMask)
The Oracle-specific
TO_NUMBER function. |
static Field<java.math.BigDecimal> |
toNumber(java.lang.String value,
java.lang.String formatMask)
The Oracle-specific
TO_NUMBER function. |
static Field<java.lang.Long> |
versionsEndscn()
The Oracle-specific
VERSIONS_ENDSCN pseudo-field. |
static Field<java.sql.Timestamp> |
versionsEndtime()
The Oracle-specific
VERSIONS_ENDTIME pseudo-field. |
static Field<java.lang.String> |
versionsOperation()
The Oracle-specific
VERSIONS_OPERATION pseudo-field. |
static Field<java.lang.Long> |
versionsStartscn()
The Oracle-specific
VERSIONS_STARTSCN pseudo-field. |
static Field<java.sql.Timestamp> |
versionsStarttime()
The Oracle-specific
VERSIONS_STARTTIME pseudo-field. |
static Field<java.lang.String> |
versionsXid()
The Oracle-specific
VERSIONS_XID pseudo-field. |
abs, abs, acos, acos, all, all, all, alterSequence, alterSequence, alterSequence, alterTable, alterTable, alterTable, and, and, any, any, any, arrayAgg, 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, choose, choose, choose, coalesce, coalesce, coalesce, coerce, coerce, coerce, coerce, coerce, coerce, concat, concat, concat, concat, condition, condition, condition, condition, condition, condition, condition, connectByIsCycle, connectByIsLeaf, connectByRoot, constraint, cos, cos, cosh, cosh, cot, cot, coth, coth, count, count, count, countDistinct, countDistinct, countDistinct, createGlobalTemporaryTable, createGlobalTemporaryTable, createGlobalTemporaryTable, createIndex, createIndex, createSequence, createSequence, createSequence, createTable, createTable, createTable, createTemporaryTable, createTemporaryTable, createTemporaryTable, createView, createView, createView, cube, cumeDist, cumeDist, currentDate, currentTime, currentTimestamp, currentUser, date, date, date, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateDiff, dateDiff, dateDiff, dateDiff, dateSub, dateSub, dateSub, dateSub, dateSub, dateSub, day, day, decode, decode, decode, decode, decode, defaultValue, defaultValue, defaultValue, defaultValue, deg, deg, delete, deleteFrom, denseRank, denseRank, dropIndex, dropIndex, dropIndexIfExists, dropIndexIfExists, dropSequence, dropSequence, dropSequence, dropSequenceIfExists, dropSequenceIfExists, dropSequenceIfExists, dropTable, dropTable, dropTable, dropTableIfExists, dropTableIfExists, dropTableIfExists, dropView, dropView, dropView, dropViewIfExists, dropViewIfExists, dropViewIfExists, dual, e, escape, escape, every, every, exists, exp, exp, extract, extract, falseCondition, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, 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, 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, list, list, 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, not, not, notExists, ntile, nullif, nullif, nullif, nullif, nullSafe, nullSafe, nullSafeDataType, nvl, nvl, nvl, nvl, nvl2, nvl2, nvl2, nvl2, octetLength, octetLength, one, or, or, orderBy, orderBy, orderBy, param, param, param, param, param, param, param, param, param, partitionBy, partitionBy, percentileCont, percentileCont, percentileDisc, percentileDisc, percentRank, percentRank, pi, position, position, position, position, power, power, power, power, prior, query, query, query, queryPart, queryPart, queryPart, rad, rad, rand, rank, rank, regrAvgX, regrAvgY, regrCount, regrIntercept, regrR2, regrSlope, regrSXX, regrSXY, regrSYY, repeat, repeat, repeat, repeat, replace, replace, replace, replace, resultQuery, resultQuery, resultQuery, 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, schema, 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, sequence, sequence, sequence, sequence, sequence, sequence, sequenceByName, sequenceByName, sequenceByName, 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, tableByName, tan, tan, tanh, tanh, time, time, time, timestamp, 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, truncate, two, unnest, unnest, unnest, unnest, update, upper, upper, using, using, using, 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, when, when, when, with, with, with, withRecursive, withRecursive, withRecursive, year, year, zero@Support(value=ORACLE) public static Field<java.lang.Integer> rownum()
ROWNUM pseudo-field.@Support(value=ORACLE) public static Field<java.lang.String> rowid()
ROWID pseudo-field.@Support(value=ORACLE) public static Field<java.lang.Long> rowscn()
ORA_ROWSCN pseudo-field.@Support(value=ORACLE) public static Field<java.lang.Long> oraRowscn()
ORA_ROWSCN pseudo-field.@Support(value=ORACLE) public static Field<java.sql.Timestamp> scnToTimestamp(java.lang.Number scn)
SCN_TO_TIMESTAMP function.@Support(value=ORACLE) public static Field<java.sql.Timestamp> scnToTimestamp(Field<? extends java.lang.Number> scn)
SCN_TO_TIMESTAMP function.@Support(value=ORACLE) public static Field<java.lang.Long> timestampToScn(java.util.Date timestamp)
TIMESTAMP_TO_SCN function.@Support(value=ORACLE) public static Field<java.lang.Long> timestampToScn(Field<? extends java.util.Date> scn)
TIMESTAMP_TO_SCN function.@Support(value=ORACLE) public static Field<java.lang.String> sysContext(java.lang.String namespace, java.lang.String parameter)
SYS_CONTEXT function.@Support(value=ORACLE) public static Field<java.lang.String> sysContext(java.lang.String namespace, java.lang.String parameter, int length)
SYS_CONTEXT function.@Support(value=ORACLE) public static Field<java.lang.String> toChar(java.lang.Object value)
TO_CHAR function.@Support(value=ORACLE) public static Field<java.lang.String> toChar(Field<?> value)
TO_CHAR function.@Support(value=ORACLE) public static Field<java.lang.String> toChar(java.lang.Object value, java.lang.String formatMask)
TO_CHAR function.@Support(value=ORACLE) public static Field<java.lang.String> toChar(java.lang.Object value, Field<java.lang.String> formatMask)
TO_CHAR function.@Support(value=ORACLE) public static Field<java.lang.String> toChar(Field<?> value, java.lang.String formatMask)
TO_CHAR function.@Support(value=ORACLE) public static Field<java.lang.String> toChar(Field<?> value, Field<java.lang.String> formatMask)
TO_CHAR function.@Support(value=ORACLE) public static Field<java.math.BigDecimal> toNumber(java.lang.String value)
TO_NUMBER function.@Support(value=ORACLE) public static Field<java.math.BigDecimal> toNumber(Field<java.lang.String> value)
TO_NUMBER function.@Support(value=ORACLE) public static Field<java.math.BigDecimal> toNumber(java.lang.String value, java.lang.String formatMask)
TO_NUMBER function.@Support(value=ORACLE) public static Field<java.math.BigDecimal> toNumber(java.lang.String value, Field<java.lang.String> formatMask)
TO_NUMBER function.@Support(value=ORACLE) public static Field<java.math.BigDecimal> toNumber(Field<java.lang.String> value, java.lang.String formatMask)
TO_NUMBER function.@Support(value=ORACLE) public static Field<java.math.BigDecimal> toNumber(Field<java.lang.String> value, Field<java.lang.String> formatMask)
TO_NUMBER function.@Support(value=ORACLE) public static Field<java.lang.Long> versionsStartscn()
VERSIONS_STARTSCN pseudo-field.@Support(value=ORACLE) public static Field<java.sql.Timestamp> versionsStarttime()
VERSIONS_STARTTIME pseudo-field.@Support(value=ORACLE) public static Field<java.lang.Long> versionsEndscn()
VERSIONS_ENDSCN pseudo-field.@Support(value=ORACLE) public static Field<java.sql.Timestamp> versionsEndtime()
VERSIONS_ENDTIME pseudo-field.@Support(value=ORACLE) public static Field<java.lang.String> versionsXid()
VERSIONS_XID pseudo-field.@Support(value=ORACLE) public static Field<java.lang.String> versionsOperation()
VERSIONS_OPERATION pseudo-field.@Support(value=ORACLE) public static Field<java.math.BigDecimal> contains(Field<java.lang.String> field, java.lang.String query)
CONTAINS function.@Support(value=ORACLE) public static Field<java.math.BigDecimal> contains(Field<java.lang.String> field, java.lang.String query, int label)
CONTAINS function.@Support(value=ORACLE) public static Field<java.math.BigDecimal> matches(Field<java.lang.String> field, java.lang.String query)
MATCHES function.@Support(value=ORACLE) public static Field<java.math.BigDecimal> matches(Field<java.lang.String> field, java.lang.String query, int label)
CONTAINS function.@Support(value=ORACLE) public static Field<java.math.BigDecimal> catsearch(Field<java.lang.String> field, java.lang.String textQuery, java.lang.String structuredQuery)
CATSEARCH function.@Support(value=ORACLE) public static Field<java.math.BigDecimal> score(int label)
SCORE function.Copyright © 2015. All Rights Reserved.