Top Description Constructors Methods
org.jooq.util.mysql

public Class MySQLDSL

extends DSL
Class Inheritance
Static Imports
org.jooq.SQLDialect.MYSQL

The SQLDialect#MYSQL specific DSL.
Author
Lukas Eder

Constructor Summary

AccessConstructor and Description
protected
MySQLDSL()

No instances

Method Summary

Modifier and TypeMethod and Description
public static @NotNull Field<String>
aesDecrypt(String cryptString, String keyString)

Deprecated as a consequence of Field being deprecated.
Get the MySQL-specific AES_DECRYPT() function.
public static @NotNull Field<byte[]>
aesDecrypt(byte[] cryptString, byte[] keyString)

Deprecated as a consequence of Field being deprecated.
Get the MySQL-specific AES_DECRYPT() function.
public static <T> @NotNull Field<T>
aesDecrypt(Field<T> cryptString, Field<T> keyString)

Deprecated as a consequence of Field being deprecated.
Get the MySQL-specific AES_DECRYPT() function.
public static @NotNull Field<String>
aesEncrypt(String string, String keyString)

Deprecated as a consequence of Field being deprecated.
Get the MySQL-specific AES_ENCRYPT() function.
public static @NotNull Field<byte[]>
aesEncrypt(byte[] string, byte[] keyString)

Deprecated as a consequence of Field being deprecated.
Get the MySQL-specific AES_ENCRYPT() function.
public static <T> @NotNull Field<T>
aesEncrypt(Field<T> string, Field<T> keyString)

Deprecated as a consequence of Field being deprecated.
Get the MySQL-specific AES_ENCRYPT() function.
public static @NotNull Field<String>
compress(String string)

Deprecated as a consequence of Field being deprecated.
Get the MySQL-specific COMPRESS() function.
public static @NotNull Field<byte[]>
compress(byte[] string)

Deprecated as a consequence of Field being deprecated.
Get the MySQL-specific COMPRESS() function.
public static <T> @NotNull Field<T>
compress(Field<T> string)

Deprecated as a consequence of Field being deprecated.
Get the MySQL-specific COMPRESS() function.
public static @NotNull Field<String>
decode(String cryptString, String keyString)

Deprecated for removal since 3.15. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
Get the MySQL-specific DECODE() function.
public static @NotNull Field<byte[]>
decode(byte[] cryptString, byte[] keyString)

Deprecated for removal since 3.15. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
Get the MySQL-specific DECODE() function.
public static <T> @NotNull Field<T>
decode(Field<T> cryptString, Field<T> keyString)

Deprecated for removal since 3.15. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
Get the MySQL-specific DECODE() function.
public static @NotNull Field<String>
desDecrypt(String cryptString)

Deprecated for removal since 3.15. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
Get the MySQL-specific DES_DECRYPT() function.
public static @NotNull Field<byte[]>
desDecrypt(byte[] cryptString)

Deprecated for removal since 3.15. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
Get the MySQL-specific DES_DECRYPT() function.
public static <T> @NotNull Field<T>
desDecrypt(Field<T> cryptString)

Deprecated for removal since 3.15. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
Get the MySQL-specific DES_DECRYPT() function.
public static @NotNull Field<String>
desDecrypt(String cryptString, String keyString)

Deprecated for removal since 3.15. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
Get the MySQL-specific DES_DECRYPT() function.
public static @NotNull Field<byte[]>
desDecrypt(byte[] cryptString, byte[] keyString)

Deprecated for removal since 3.15. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
Get the MySQL-specific DES_DECRYPT() function.
public static <T> @NotNull Field<T>
desDecrypt(Field<T> cryptString, Field<T> keyString)

Deprecated for removal since 3.15. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
Get the MySQL-specific DES_DECRYPT() function.
public static @NotNull Field<String>
desEncrypt(String string)

Deprecated for removal since 3.15. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
Get the MySQL-specific DES_ENCRYPT() function.
public static @NotNull Field<byte[]>
desEncrypt(byte[] string)

Deprecated for removal since 3.15. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
Get the MySQL-specific DES_ENCRYPT() function.
public static <T> @NotNull Field<T>
desEncrypt(Field<T> string)

Deprecated for removal since 3.15. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
Get the MySQL-specific DES_ENCRYPT() function.
public static @NotNull Field<String>
desEncrypt(String string, String keyString)

Deprecated for removal since 3.15. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
Get the MySQL-specific DES_ENCRYPT() function.
public static @NotNull Field<byte[]>
desEncrypt(byte[] string, byte[] keyString)

Deprecated for removal since 3.15. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
Get the MySQL-specific DES_ENCRYPT() function.
public static <T> @NotNull Field<T>
desEncrypt(Field<T> string, Field<T> keyString)

Deprecated for removal since 3.15. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
Get the MySQL-specific DES_ENCRYPT() function.
public static @NotNull Field<String>
encode(String string, String keyString)

Deprecated for removal since 3.15. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
Get the MySQL-specific ENCODE() function.
public static @NotNull Field<byte[]>
encode(byte[] string, byte[] keyString)

Deprecated for removal since 3.15. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
Get the MySQL-specific ENCODE() function.
public static <T> @NotNull Field<T>
encode(Field<T> string, Field<T> keyString)

Deprecated for removal since 3.15. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
Get the MySQL-specific ENCODE() function.
public static <E extends Enum<E> & EnumType> E
enumType(Class<E> type, int index)

Get a field based EnumType by its MySQL-specific index.

public static @NotNull Field<String>
password(String string)

Deprecated for removal since 3.15. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
Get the MySQL-specific PASSWORD() function.
public static @NotNull Field<byte[]>
password(byte[] string)

Deprecated for removal since 3.15. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
Get the MySQL-specific PASSWORD() function.
public static <T> @NotNull Field<T>
password(Field<T> string)

Deprecated for removal since 3.15. - 3.15.0 - [#8611] - This function has been removed from MySQL 8
Get the MySQL-specific PASSWORD() function.
public static @NotNull Field<String>
sha1(String string)

Deprecated as a consequence of Field being deprecated.
Get the MySQL-specific SHA1() function.
public static @NotNull Field<byte[]>
sha1(byte[] string)

Deprecated as a consequence of Field being deprecated.
Get the MySQL-specific SHA1() function.
public static <T> @NotNull Field<T>
sha1(Field<T> string)

Deprecated as a consequence of Field being deprecated.
Get the MySQL-specific SHA1() function.
public static @NotNull Field<String>
sha2(String string, int hashLength)

Deprecated as a consequence of Field being deprecated.
Get the MySQL-specific SHA2() function.
public static @NotNull Field<byte[]>
sha2(byte[] string, int hashLength)

Deprecated as a consequence of Field being deprecated.
Get the MySQL-specific SHA2() function.
public static <T> @NotNull Field<T>
sha2(Field<T> string, Field<Integer> hashLength)

Deprecated as a consequence of Field being deprecated.
Get the MySQL-specific SHA2() function.
public static @NotNull Field<String>
uncompress(String string)

Deprecated as a consequence of Field being deprecated.
Get the MySQL-specific UNCOMPRESS() function.
public static @NotNull Field<byte[]>
uncompress(byte[] string)

Deprecated as a consequence of Field being deprecated.
Get the MySQL-specific UNCOMPRESS() function.
public static <T> @NotNull Field<T>
uncompress(Field<T> string)

Deprecated as a consequence of Field being deprecated.
Get the MySQL-specific UNCOMPRESS() function.
public static @NotNull Field<Integer>
uncompressedLength(String string)

Deprecated as a consequence of Field being deprecated.
Get the MySQL-specific UNCOMPRESSED_LENGTH() function.
public static @NotNull Field<Integer>
uncompressedLength(byte[] string)

Deprecated as a consequence of Field being deprecated.
Get the MySQL-specific UNCOMPRESSED_LENGTH() function.
public static <T> @NotNull Field<Integer>
uncompressedLength(Field<T> string)

Deprecated as a consequence of Field being deprecated.
Get the MySQL-specific UNCOMPRESSED_LENGTH() function.
public static <T> @NotNull Field<T>
values(Field<T> values)

Deprecated for removal. - 3.15.0 - [#12099] - MySQL 8.0.20 has deprecated this clause and replaced it by something new, which we'll support soon, see https://dev.mysql.com/doc/refman/8.0/en/insert-on-duplicate.html/ and https://github.com/jOOQ/jOOQ/issues/12099
Get the MySQL-specific VALUES() function for use with INSERT … ON DUPLICATE KEY UPDATE statements.
Inherited from org.jooq.impl.DSL:
absabsacosacosacoshacoshacothacothaggregateaggregateaggregateaggregateaggregateDistinctaggregateDistinctaggregateDistinctaggregateDistinctallallallallalterDatabasealterDatabasealterDatabasealterDatabaseIfExistsalterDatabaseIfExistsalterDatabaseIfExistsalterDomainalterDomainalterDomainalterDomainIfExistsalterDomainIfExistsalterDomainIfExistsalterIndexalterIndexalterIndexalterIndexIfExistsalterIndexIfExistsalterIndexIfExistsalterSchemaalterSchemaalterSchemaalterSchemaIfExistsalterSchemaIfExistsalterSchemaIfExistsalterSequencealterSequencealterSequencealterSequenceIfExistsalterSequenceIfExistsalterSequenceIfExistsalterTablealterTablealterTablealterTableIfExistsalterTableIfExistsalterTableIfExistsalterTypealterTypealterViewalterViewalterViewalterViewalterViewalterViewIfExistsalterViewIfExistsalterViewIfExistsandandandanyanyanyanyanyValuearrayarrayarrayarrayarrayAggarrayAggDistinctarrayAppendarrayAppendarrayAppendarrayAppendarrayConcatarrayConcatarrayConcatarrayConcatarrayGetarrayGetarrayOverlaparrayOverlaparrayOverlaparrayOverlaparrayPrependarrayPrependarrayPrependarrayPrependarrayRemovearrayRemovearrayRemovearrayRemovearrayReplacearrayReplaceasciiasciiasinasinasinhasinhasteriskatanatanatan2atan2atan2atan2atanhatanhavgavgDistinctbeginbeginbitAndbitAndbitAndbitAndbitAndAggbitCountbitCountbitGetbitGetbitLengthbitLengthbitNandbitNandbitNandbitNandbitNandAggbitNorbitNorbitNorbitNorbitNorAggbitNotbitNotbitOrbitOrbitOrbitOrbitOrAggbitSetbitSetbitSetbitSetbitSetbitSetbitXNorbitXNorbitXNorbitXNorbitXNorAggbitXorbitXorbitXorbitXorbitXorAggboolAndboolAndboolOrboolOrcardinalitycase_case_case_castcastcastcastcastcastcastNullcastNullcastNullcatalogcatalogceilceilcenturycenturycenturycharacterSetcharacterSetcharLengthcharLengthcheckchoosechoosechoosechoosechoosechoosechoosechrchrcoalescecoalescecoalescecoercecoercecoercecoercecoercecoercecollationcollationcommentcommentOnColumncommentOnColumncommentOnColumncommentOnTablecommentOnTablecommentOnTablecommentOnViewcommentOnViewcommentOnViewcommitconcatconcatconcatconcatconditionconditionconditionconditionconditionconditionconditionconditionconditionconditionconditionconstraintconstraintconstraintcorrcoscoscoshcoshcotcotcothcothcountcountcountcountcountDistinctcountDistinctcountDistinctcountDistinctcovarPopcovarSampcreateDatabasecreateDatabasecreateDatabasecreateDatabaseIfNotExistscreateDatabaseIfNotExistscreateDatabaseIfNotExistscreateDomaincreateDomaincreateDomaincreateDomainIfNotExistscreateDomainIfNotExistscreateDomainIfNotExistscreateGlobalTemporaryTablecreateGlobalTemporaryTablecreateGlobalTemporaryTablecreateGlobalTemporaryTableIfNotExistscreateGlobalTemporaryTableIfNotExistscreateGlobalTemporaryTableIfNotExistscreateIndexcreateIndexcreateIndexcreateIndexcreateIndexIfNotExistscreateIndexIfNotExistscreateIndexIfNotExistscreateIndexIfNotExistscreateOrReplaceViewcreateOrReplaceViewcreateOrReplaceViewcreateOrReplaceViewcreateOrReplaceViewcreateOrReplaceViewcreateSchemacreateSchemacreateSchemacreateSchemaIfNotExistscreateSchemaIfNotExistscreateSchemaIfNotExistscreateSequencecreateSequencecreateSequencecreateSequenceIfNotExistscreateSequenceIfNotExistscreateSequenceIfNotExistscreateTablecreateTablecreateTablecreateTableIfNotExistscreateTableIfNotExistscreateTableIfNotExistscreateTemporaryTablecreateTemporaryTablecreateTemporaryTablecreateTemporaryTableIfNotExistscreateTemporaryTableIfNotExistscreateTemporaryTableIfNotExistscreateTypecreateTypecreateUniqueIndexcreateUniqueIndexcreateUniqueIndexcreateUniqueIndexcreateUniqueIndexIfNotExistscreateUniqueIndexIfNotExistscreateUniqueIndexIfNotExistscreateUniqueIndexIfNotExistscreateViewcreateViewcreateViewcreateViewcreateViewcreateViewcreateViewIfNotExistscreateViewIfNotExistscreateViewIfNotExistscreateViewIfNotExistscreateViewIfNotExistscreateViewIfNotExistscubecubecumeDistcumeDistcumeDistcurrentCatalogcurrentDatecurrentInstantcurrentLocalDatecurrentLocalDateTimecurrentLocalDateTimecurrentLocalDateTimecurrentLocalTimecurrentOffsetDateTimecurrentOffsetTimecurrentSchemacurrentTimecurrentTimestampcurrentTimestampcurrentTimestampcurrentUserdatedatedatedateAdddateAdddateAdddateAdddateAdddateAdddateAdddateAdddateDiffdateDiffdateDiffdateDiffdateDiffdateDiffdateDiffdateDiffdateSubdateSubdateSubdateSubdateSubdateSubdateSubdateSubdaydaydaydayOfWeekdayOfWeekdayOfWeekdayOfYeardayOfYeardayOfYeardecadedecadedecadedecodedecodedecodedecodedecodedefault_default_default_default_defaultValuedefaultValuedefaultValuedefaultValuedegdegdeletedeleteFromdenseRankdenseRankdenseRankdigitsdigitsdomaindomaindropDatabasedropDatabasedropDatabasedropDatabaseIfExistsdropDatabaseIfExistsdropDatabaseIfExistsdropDomaindropDomaindropDomaindropDomainIfExistsdropDomainIfExistsdropDomainIfExistsdropIndexdropIndexdropIndexdropIndexIfExistsdropIndexIfExistsdropIndexIfExistsdropSchemadropSchemadropSchemadropSchemaIfExistsdropSchemaIfExistsdropSchemaIfExistsdropSequencedropSequencedropSequencedropSequenceIfExistsdropSequenceIfExistsdropSequenceIfExistsdropTabledropTabledropTabledropTableIfExistsdropTableIfExistsdropTableIfExistsdropTemporaryTabledropTemporaryTabledropTemporaryTabledropTemporaryTableIfExistsdropTemporaryTableIfExistsdropTemporaryTableIfExistsdropTypedropTypedropTypedropTypedropTypedropTypeIfExistsdropTypeIfExistsdropTypeIfExistsdropTypeIfExistsdropTypeIfExistsdropViewdropViewdropViewdropViewIfExistsdropViewIfExistsdropViewIfExistsdualeemptyGroupingSetepochepochepochescapeescapeeveryeveryexcludedexistsexpexpextractextractextractfalseConditionfieldfieldfieldfieldfieldfieldfieldfieldfieldfieldfieldfieldfieldfieldfieldfieldfieldfieldfieldfieldfieldfinalTablefinalTablefinalTablefirstValuefloorfloorforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyforeignKeyfunctionfunctionfunctionfunctiongenerateSeriesgenerateSeriesgenerateSeriesgenerateSeriesgenerateSeriesgenerateSeriesgenerateSeriesgenerateSeriesgenerateSeriesgenerateSeriesgenerateSeriesgenerateSeriesgetDataTypegrantgrantgrantgreatestgreatestgroupConcatgroupConcatgroupConcatDistinctgroupinggroupingSetsgroupingSetsgroupingSetsgroupsBetweenCurrentRowgroupsBetweenFollowinggroupsBetweenPrecedinggroupsBetweenUnboundedFollowinggroupsBetweenUnboundedPrecedinggroupsCurrentRowgroupsFollowinggroupsPrecedinggroupsUnboundedFollowinggroupsUnboundedPrecedinghourhourhourif_if_if_if_ifnullifnullifnullifnulliifiifiifiifininindexinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlineinlinedinlinedinlinedinOutinOutinsertinsertinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinsertIntoinstantinstantinstantisnullisnullisnullisnullisoDayOfWeekisoDayOfWeekisoDayOfWeekjsonArrayjsonArrayjsonArrayAggjsonArrayAggDistinctjsonbArrayjsonbArrayjsonbArrayAggjsonbArrayAggDistinctjsonbExistsjsonbExistsjsonbGetAttributejsonbGetAttributejsonbGetAttributejsonbGetAttributejsonbGetAttributeAsTextjsonbGetAttributeAsTextjsonbGetAttributeAsTextjsonbGetAttributeAsTextjsonbGetElementjsonbGetElementjsonbGetElementjsonbGetElementjsonbGetElementAsTextjsonbGetElementAsTextjsonbGetElementAsTextjsonbGetElementAsTextjsonbInsertjsonbInsertjsonbInsertjsonbInsertjsonbKeysjsonbKeysjsonbObjectjsonbObjectjsonbObjectjsonbObjectjsonbObjectjsonbObjectjsonbObjectjsonbObjectAggjsonbObjectAggjsonbObjectAggjsonbObjectAggjsonbRemovejsonbRemovejsonbReplacejsonbReplacejsonbReplacejsonbReplacejsonbSetjsonbSetjsonbSetjsonbSetjsonbTablejsonbTablejsonbValuejsonbValuejsonEntryjsonEntryjsonEntryjsonEntryjsonEntryjsonEntryjsonEntryjsonExistsjsonExistsjsonGetAttributejsonGetAttributejsonGetAttributejsonGetAttributejsonGetAttributeAsTextjsonGetAttributeAsTextjsonGetAttributeAsTextjsonGetAttributeAsTextjsonGetElementjsonGetElementjsonGetElementjsonGetElementjsonGetElementAsTextjsonGetElementAsTextjsonGetElementAsTextjsonGetElementAsTextjsonInsertjsonInsertjsonInsertjsonInsertjsonKeysjsonKeysjsonObjectjsonObjectjsonObjectjsonObjectjsonObjectjsonObjectjsonObjectjsonObjectAggjsonObjectAggjsonObjectAggjsonObjectAggjsonRemovejsonRemovejsonReplacejsonReplacejsonReplacejsonReplacejsonSetjsonSetjsonSetjsonSetjsonTablejsonTablejsonValuejsonValuekeykeykeywordlaglaglaglaglaglaglaglastValuelateralleadleadleadleadleadleadleadleastleastleftleftleftleftlengthlengthlistlistlistAgglistAgglistAggDistinctlistAggDistinctlnlnlocalDatelocalDatelocalDatelocalDateAddlocalDateAddlocalDateAddlocalDateAddlocalDateAddlocalDateAddlocalDateAddlocalDateAddlocalDateDifflocalDateDifflocalDateDifflocalDateDifflocalDateDifflocalDateDifflocalDateDifflocalDateDifflocalDateSublocalDateSublocalDateSublocalDateSublocalDateSublocalDateSublocalDateTimelocalDateTimelocalDateTimelocalDateTimeAddlocalDateTimeAddlocalDateTimeAddlocalDateTimeAddlocalDateTimeAddlocalDateTimeAddlocalDateTimeAddlocalDateTimeAddlocalDateTimeDifflocalDateTimeDifflocalDateTimeDifflocalDateTimeDifflocalDateTimeDifflocalDateTimeDifflocalDateTimeDifflocalDateTimeDifflocalDateTimeSublocalDateTimeSublocalDateTimeSublocalDateTimeSublocalDateTimeSublocalDateTimeSublocalTimelocalTimelocalTimelogloglogloglog10log10lowerlowerlpadlpadlpadlpadlpadlpadlpadltrimltrimltrimltrimltrimltrimmaxmaxDistinctmd5md5medianmergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomergeIntomicrosecondmicrosecondmicrosecondmidmidmidmidmidmidmillenniummillenniummillenniummillisecondmillisecondmillisecondminminDistinctminusminuteminuteminutemodemodemonthmonthmonthmultisetmultisetAggmultisetAggmultisetAggmultisetAggmultisetAggmultisetAggmultisetAggmultisetAggmultisetAggmultisetAggmultisetAggmultisetAggmultisetAggmultisetAggmultisetAggmultisetAggmultisetAggmultisetAggmultisetAggmultisetAggmultisetAggmultisetAggmultisetAggmultisetAggmultisetAggDistinctmultisetAggDistinctmultisetAggDistinctmultisetAggDistinctmultisetAggDistinctmultisetAggDistinctmultisetAggDistinctmultisetAggDistinctmultisetAggDistinctmultisetAggDistinctmultisetAggDistinctmultisetAggDistinctmultisetAggDistinctmultisetAggDistinctmultisetAggDistinctmultisetAggDistinctmultisetAggDistinctmultisetAggDistinctmultisetAggDistinctmultisetAggDistinctmultisetAggDistinctmultisetAggDistinctmultisetAggDistinctmultisetAggDistinctnamenamenamenamenegnewTablenewTablenewTablenoConditionnoFieldnoFieldnoFieldnoFieldnotnotnotExistsnotUniquenownownthValuenthValuentilentilenullConditionnullifnullifnullifnullifnullSafenullSafenullSafenullSafenullSafeDataTypenullSafeListnullSafeListnvlnvlnvlnvlnvl2nvl2nvl2nvl2octetLengthoctetLengthoffsetDateTimeoffsetDateTimeoffsetDateTimeoffsetTimeoffsetTimeoffsetTimeoldTableoldTableoldTableoneororororderByorderByorderByoutoutoverlayoverlayoverlayoverlayparamparamparamparamparamparamparamparamparampartitionBypartitionBypercentileContpercentileContpercentileDiscpercentileDiscpercentRankpercentRankpercentRankpipositionpositionpositionpositionpositionpositionpositionpositionpositionpositionpositionpositionpowerpowerpowerpowerprimaryKeyprimaryKeyprimaryKeyprimaryKeyprivilegeproductproductDistinctquarterquarterquarterqueriesqueriesqueryqueryqueryqueryquotedNamequotedNamequotedNameradradrandrangeBetweenCurrentRowrangeBetweenFollowingrangeBetweenPrecedingrangeBetweenUnboundedFollowingrangeBetweenUnboundedPrecedingrangeCurrentRowrangeFollowingrangePrecedingrangeUnboundedFollowingrangeUnboundedPrecedingrankrankrankratioToReportratioToReportrawrecordTyperecordTyperecordTyperecordTyperecordTyperecordTyperecordTyperecordTyperecordTyperecordTyperecordTyperecordTyperecordTyperecordTyperecordTyperecordTyperecordTyperecordTyperecordTyperecordTyperecordTyperecordTyperecordTyperecordTyperegexpReplaceAllregexpReplaceAllregexpReplaceFirstregexpReplaceFirstregrAvgXregrAvgYregrCountregrInterceptregrR2regrSloperegrSXXregrSXYregrSYYreleaseSavepointreleaseSavepointrepeatrepeatrepeatrepeatreplacereplacereplacereplacereplacereplaceresultQueryresultQueryresultQueryresultQueryreversereverserevokerevokerevokerevokeGrantOptionForrevokeGrantOptionForrevokeGrantOptionForrightrightrightrightrolerolerollbackrolluprolluproundroundroundroundroundroundrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowrowFieldrowFieldrowFieldrowFieldrowFieldrowFieldrowFieldrowFieldrowFieldrowFieldrowFieldrowFieldrowFieldrowFieldrowFieldrowFieldrowFieldrowFieldrowFieldrowFieldrowFieldrowFieldrowFieldrowNumberrowsBetweenCurrentRowrowsBetweenFollowingrowsBetweenPrecedingrowsBetweenUnboundedFollowingrowsBetweenUnboundedPrecedingrowsCurrentRowrowsFollowingrowsFromrowsPrecedingrowsUnboundedFollowingrowsUnboundedPrecedingrpadrpadrpadrpadrpadrpadrpadrtrimrtrimrtrimrtrimrtrimrtrimsavepointsavepointschemaschemasecondsecondsecondselectselectselectselectselectselectselectselectselectselectselectselectselectselectselectselectselectselectselectselectselectselectselectselectselectCountselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectDistinctselectFromselectFromselectFromselectFromselectFromselectFromselectOneselectZerosequencesequencesequencesequencesequencesequencesetsetsetCatalogsetCatalogsetCatalogsetLocalsetLocalsetSchemasetSchemasetSchemashlshlshlshlshrshrshrshrsignsignsinsinsinhsinhspacespacesplitPartsplitPartsplitPartsplitPartsqlsqlsqlsqrtsqrtsquaresquarestartTransactionstddevPopstddevSampsubstringsubstringsubstringsubstringsubstringsubstringsubstringIndexsubstringIndexsubstringIndexsubstringIndexsumsumDistinctsystemNamesystemNamesystemNametabletabletabletabletabletabletabletabletabletabletabletabletabletantantanhtanhtautimetimetimetimestamptimestamptimestamptimestampAddtimestampAddtimestampAddtimestampAddtimestampAddtimestampAddtimestampAddtimestampAddtimestampDifftimestampDifftimestampDifftimestampDifftimestampDifftimestampDifftimestampDifftimestampDifftimestampSubtimestampSubtimestampSubtimestampSubtimestampSubtimestampSubtimezonetimezonetimezonetimezoneHourtimezoneHourtimezoneHourtimezoneMinutetimezoneMinutetimezoneMinutetoChartoChartoChartoChartoChartoChartoDatetoDatetoDatetoDatetoHextoHextoLocalDatetoLocalDatetoLocalDatetoLocalDatetoLocalDateTimetoLocalDateTimetoLocalDateTimetoLocalDateTimetoTimestamptoTimestamptoTimestamptoTimestamptranslatetranslatetranslatetranslatetrimtrimtrimtrimtrimtrimtrueConditiontrunctrunctrunctrunctrunctrunctrunctrunctrunctrunctrunctrunctrunctrunctrunctruncatetruncatetruncatetruncateTabletruncateTabletruncateTabletwouniqueuniqueuniqueuniqueuniqueunnestunnestunnestunquotedNameunquotedNameunquotedNameupdateupperupperuseruserusingusingusingusingusingusingusingusingusingusingusingusingusingusingusingusingusingusingusingusinguuidvalvalvalvalvalvalvalvalvalvalvalvalvalvalvalvalvalvalvalvalvalvalvalvalvalvalvalvalvalvalvalvalvalvalvalvalvalvalvalvaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluevaluesvaluesvaluesvaluesvaluesvaluesvaluesvaluesvaluesvaluesvaluesvaluesvaluesvaluesvaluesvaluesvaluesvaluesvaluesvaluesvaluesvaluesvaluesvarPopvarSampweekweekweekwhenwhenwhenwhenwhenwhenwidthBucketwidthBucketwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithwithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivewithRecursivexmlaggxmlattributesxmlattributesxmlcommentxmlcommentxmlconcatxmlconcatxmlelementxmlelementxmlelementxmlelementxmlelementxmlelementxmlelementxmlelementxmlexistsxmlexistsxmlforestxmlforestxmlparseContentxmlparseContentxmlparseDocumentxmlparseDocumentxmlpixmlpixmlpixmlpixmlqueryxmlqueryxmlserializeContentxmlserializeContentxmlserializeDocumentxmlserializeDocumentxmltablexmltablexorxorxoryearyearyearzero