SQL

BASICSSELECTINSERTUPDATEDELETE
AND, OR, NOTAGGREGATE FUNCTIONS - MINAGGREGATE FUNCTIONS - MAXAGGREGATE FUNCTIONS - SUMAGGREGATE FUNCTIONS - COUNT
AGGREGATE FUNCTIONS - AVGLIKEIN, BETWEENINNER JOINLEFT (OUTER) JOIN
RIGHT (OUTER) JOINFULL (OUTER) JOINSELF JOINUNION, UNION ALLGROUP BY, HAVING
EXISTS, NOT EXISTSIS NULL, IS NOT NULLTRUNCATEDISTINCT, ORDER BY

 

TYPEFUNCTION NAMEFUNCTION DESCRIPTION
STRINGASCIIReturns the number code that represents the specified character
STRINGASCIISTRConverts a string in any character set to an ASCII string using the database character set
STRINGCHRReturns the character based on the number code
STRINGCOMPOSEReturns a Unicode string
STRINGCONCATAllows you to concatenate two strings together
STRINGConcat with ||Allows you to concatenate two or more strings together
STRINGCONVERTConverts a string from one character set to another
STRINGDECOMPOSEAccepts a string and returns a Unicode string
STRINGDUMPReturns a varchar2 value that includes the datatype code, the length in bytes, and the internal representation of the expression
STRINGINITCAPSets the first character in each word to uppercase and the rest to lowercase
STRINGINSTRReturns the location of a sub string in a string
STRINGINSTR2Returns the location of a sub string in a string, using UCS2 code points
STRINGINSTR4Returns the location of a sub string in a string, using UCS4 code points
STRINGINSTRBReturns the location of a substring in a string, using bytes instead of characters
STRINGINSTRCReturns the location of a substring in a string, using Unicode complete characters
STRINGLENGTHReturns the length of the specified string
STRINGLENGTH2Returns the length of the specified string, using UCS2 code points
STRINGLENGTH4Returns the length of the specified string, using UCS4 code points
STRINGLENGTHBReturns the length of the specified string, using bytes instead of characters
STRINGLENGTHCReturns the length of the specified string, using Unicode complete of characters
STRINGLOWERConverts all letters in the specified string to lowercase
STRINGLPADPads the left-side of a string with a specific set of characters
STRINGLTRIMRemoves all specified characters from the left-hand side of a string
STRINGNCHRReturns the character based on the number code in the national character set
STRINGREGEXP_INSTRReturns the location of a regular expression pattern in a string
STRINGREGEXP_REPLACEAllows you to replace a sequence of characters in a string with another set of characters using regular expression pattern matching
STRINGREGEXP_SUBSTRAllows you to extract a substring from a string using regular expression pattern matching
STRINGREPLACEReplaces a sequence of characters in a string with another set of characters
STRINGRPADPads the right-side of a string with a specific set of characters
STRINGRTRIMRemoves all specified characters from the right-hand side of a string
STRINGSOUNDEXReturns a phonetic representation (the way it sounds) of a string
STRINGSUBSTRAllows you to extract a substring from a string
STRINGTRANSLATEReplaces a sequence of characters in a string with another set of characters
STRINGTRIMRemoves all specified characters either from the beginning or the end of a string
STRINGUPPERConverts all letters in the specified string to uppercase
STRINGVSIZEReturns the number of bytes in the internal representation of an expression
NUMERICABSReturns the absolute value of a number
NUMERICACOSReturns the arc cosine of a number
NUMERICASINReturns the arc sine of a number
NUMERICATANReturns the arc tangent of a number
NUMERICATAN2Returns the arc tangent of n and m
NUMERICAVGReturns the average value of an expression
NUMERICBITANDReturns an integer representing an AND operation on the bits of expr1 and expr2
NUMERICCEILReturns the smallest integer value that is greater than or equal to a number
NUMERICCOSReturns the cosine of a number
NUMERICCOSHReturns the hyperbolic cosine of a number
NUMERICCOUNTReturns the count of an expression
NUMERICEXPReturns e raised to the power of number
NUMERICFLOORReturns the largest integer value that is equal to or less than a number
NUMERICGREATESTReturns the greatest value in a list of expressions
NUMERICLEASTReturns the smallest value in a list of expressions
NUMERICLNReturns the natural logarithm of a number
NUMERICLOGReturns the natural logarithm of a number to a specified base
NUMERICMAXReturns the maximum value of an expression
NUMERICMEDIANReturns the median of an expression
NUMERICMINReturns the minimum value of an expression
NUMERICMODReturns the remainder of n divided by m
NUMERICPOWERReturns m raised to the nth power
NUMERICREGEXP_COUNTCounts the number of times that a pattern occurs in a string
NUMERICREMAINDERReturns the remainder of m divided by n
NUMERICROUNDReturns a number rounded to a certain number of decimal places
NUMERICROWNUMReturns a number that represents the order that a row is
NUMERICSIGNReturns a value indicating the sign of a number
NUMERICSINReturns the sine of a number
NUMERICSQRTReturns the square root of a number
NUMERICSUMReturns the summed value of an expression
NUMERICTANReturns the tangent of a number
NUMERICTANHReturns the hyperbolic tangent of n
NUMERICTRUNCReturns a number truncated to a certain number of decimal places
DATEADD_MONTHSReturns a date with a specified number of months added
DATECURRENT_DATEReturns the current date in the time zone of the current SQL session as set by the ALTER SESSION command
DATECURRENT_TIMESTAMPReturns the current date and time in the time zone of the current SQL session as set by the ALTER SESSION command
DATEDBTIMEZONEreturns the database time zone as a time zone offset or a time zone region name
DATEEXTRACTExtracts a value from a date or interval value
DATELAST_DAYReturns the last day of the month based on a date value
DATELOCALTIMESTAMPReturns the current date and time in the time zone of the current SQL session as set by the ALTER SESSION command
DATEMONTHS_BETWEENReturns the number of months between date1 and date2
DATENEW_TIMEConverts a date from time zone1 to a date in time zone2
DATENEXT_DAYReturns the first weekday that is greater than a date
DATEROUNDReturns a date rounded to a specific unit of measure
DATESESSIONTIMEZONEReturns the current session's time zone as a time zone offset or a time zone region name
DATESYSDATEReturns the current system date and time on your local database
DATESYSTIMESTAMPReturns the current system date and time (including fractional seconds and time zone) on your local database
DATETRUNCReturns a date truncated to a specific unit of measure
DATETZ_OFFSETReturns the time zone offset of a value