Returns the datetime resulting from adding integer_exp months to date_exp.
add_months ( date_exp, integer_exp )
Returns a number representing the ascii code value of the leftmost character of string_exp, e.g. ascii('A') is 65.
ascii ( string_exp )
Returns the smallest integer greater than or equal to numeric_exp.
ceil ( numeric_exp )
Returns the number of characters in string_exp.
char_length ( string_exp )
Returns the character that has the ASCII code value specified by integer_exp. integer_exp should be between 0 and 255.
chr ( integer_exp )
Returns a string that is the result of concatenating string_exp1 to string_exp2.
concat ( string_exp1, string_exp2 )
DECODE compares expr to each search value one by one. If expr is equal to a search, then returns the corresponding result. If no match is found, then returns default. If default is omitted, then returns null.
decode ( expr , search , result [, search , result]... [, default] )
Returns internal representation of 'expr' with the format of numeric_exp1 starting from position numeric_exp2 for numeric_exp3.
dump ( expr [ , numeric_exp1 [ , numeric_exp2 [ , numeric_exp3 ] ] ] )
Returns the greatest value in a list of expressions.
greatest ( exp_list )
Returns string_exp, with the first letter of each word in uppercase, all other letters in lowercase. Words are delimited by white space or characters that are not alphanumeric.
initcap ( string_exp )
Searches string_exp1 from the integer_exp1 position for the (integer_exp2)th occurance of string_exp2. If integer_exp1 is negative then the search is backwards from the end of string_exp1. Returns an integer indicating the position of string_exp2.
instr ( string_exp1, string_exp2 [ , integer_exp1 [ , integer_exp2 ] ] )
Searches string_exp1 from the integer_exp1 position for the (integer_exp2)th occurance of string_exp2. If integer_exp1 is negative then the search is backwards from the end of string_exp1. The result returned indicates the position (byte number) where search was found.
instrb ( string_exp1, string_exp2 [ , integer_exp1 [ , integer_exp2 ] ] )
Returns the least value in a list of expressions.
least ( exp_list )
Returns the number of characters in string_exp.
length ( string_exp )
Returns the number of bytes in string_exp.
lengthb ( string_exp )
Returns string_exp1 padded to length integer_exp with occurrences of string_exp2. If string_exp1 is longer than integer_exp then returns the appropriate portion of string_exp1.
lpad ( string_exp1, integer_exp [ , string_exp2 ] )
Returns string_exp1, with leading characters removed up to the first character not in string_exp2, e.g. ltrim('xyxXxyAB', 'xy') returns 'XxyAB'.
ltrim ( string_exp1 [ , string_exp2 ] )
Returns the number of months from date_exp1 to date_exp2. If date_exp1 is later than date_exp2 then the result will be a positive number. The days and time portion of the difference are ignored, i.e. the months are not rounded, except if date_exp1 and date_exp2 are the last days of a month.
months_between ( date_exp1, date_exp2 )
Returns the Datetime in timezone 'new_tz' for 'datetime' in 'old_tz' timezone. 'Old_tz' and 'new_tz' can be one of 'AST', 'ADT', 'BST', 'BDT', 'CST', 'CDT', 'EST', 'EDT', 'HST', 'HDT', 'MST', 'MDT', 'NST', 'PST', 'PDT', 'YST' or 'YDT'.
new_time ( datetime_exp, old_tz, new_tz )
Returns the datetime of the first weekday named by string_exp that is later than datetime_exp. The return value has the same hours, minutes, and seconds as datetime_exp.
next_day ( datetime_exp, string_exp )
Returns string_exp1 with the first letter of each word in uppercase, all other letters in lowercase. Words are delimited by white space or characters that are not alphanumeric. string_exp2 specifies the sorting sequence.
nls_initcap ( string_exp1 [ , string_exp2 ] )
Returns string_exp1 with all letters in lowercase. string_exp2 specifies the sorting sequence.
nls_lower ( string_exp1 [ , string_exp2 ] )
Returns string_exp1 with all letters in uppercase. string_exp2 specifies the sorting sequence.
nls_upper ( string_exp1 [ , string_exp2 ] )
If exp is null (missing) returns constant. If exp is not null returns exp. Valid for numeric_exp, string_exp, date_exp, and time_exp.
nvl ( exp, constant )
Replaces all occurrences of string_exp2 in string_exp1 with string_exp3. If string_exp3 is not specified then it replaces all occurrences with null (ie: removes all occurances of string_exp2).
replace ( string_exp1, string_exp2 [ , string_exp3 ] )
Returns numeric_exp rounded to the nearest value integer_exp places right of the decimal point. If integer_exp is negative, numeric_exp is rounded to the nearest value absolute (integer_exp) places to the left of the decimal point, e.g., round (125, -1) rounds to 130.
round ( numeric_exp [ , integer_exp ] )
Returns string_exp1 right-padded to length integer_exp with occurrences of string_exp2. If string_exp1 is longer than integer_exp then returns the appropriate portion of string_exp1. If string_exp2 is not specified then spaces are used.
rpad ( string_exp1, integer_exp [ , string_exp2 ] )
Returns string_exp1, with final characters removed after the last character not in string_exp2, e.g. rtrim('ABxXxyx', 'xy') returns 'ABxX'. If string_exp2 is not specified it removes th final space characters.
rtrim ( string_exp1 [ , string_exp2 ] )
Returns an indicator of the sign of numeric_exp: +1 if numeric_exp is positive, 0 if zero or -1 if negative.
sign ( numeric_exp )
Returns a character string containing the phonetic representation of string_exp.
soundex ( string_exp )
Returns the substring of string_exp that starts at position integer_exp1. The first character in string_exp is at position 1. integer_exp2 can be used to select fewer characters, by default it selects character to the end of the string.
substr ( string_exp, integer_exp1 [ , integer_exp2 ] )
Same as substr, except that the arguments are expressed in bytes (not characters).
substrb ( string_exp, numeric_exp1 [ , numeric_exp2 ] )
Returns a datetime value representing the current date and time of the computer that the database software runs on.
{ sysdate }
Returns the string representation of exp with the format of string_exp. exp can either be a date value or a numeric value.
to_char ( exp [ , string_exp ] )
Converts string_exp1 to a datetime value as specified by the format string_exp2. string_exp3 specifies format elements such as language.
to_date ( string_exp1 [ , string_exp2 [ , string_exp3 ] ] )
Converts string_exp1 to a numeric value as specified by the format string_exp2. string_exp3 specifies format elements such as currency information.
to_number ( string_exp1, string_exp2, string_exp3 )
Returns string_exp1, with all occurrences of each character in string_exp2 replaced by its corresponding character in string_exp3.
translate ( string_exp1, string_exp2, string_exp3 )
Truncates the date_exp using the format specified by string_exp. For example, if string_exp is 'YEAR' then date_exp is truncated to the first day of the year.
trunc ( date_exp, string_exp )
Truncates digits from numeric_exp1 using numeric_exp2 as the precision.
trunc ( numeric_exp1, numeric_exp2 )
Returns the username of the current Oracle user.
{ user }
Returns the number of bytes in the internal representation of 'exp'. 'exp' must be a string expression.
vsize ( exp )
Returns the logarithm of numeric_exp2 to the base numeric_exp1.
log ( numeric_exp1, numeric_exp2 )
Returns the arccosine of numeric_exp in radians. The arccosine is the angle whose cosine is numeric_exp.
acos ( numeric_exp )
Returns the arcsine of numeric_exp in radians. The arcsine is the angle whose sine is numeric_exp.
asin ( numeric_exp )
Returns the arctangent of numeric_exp in radians. The arctangent is the angle whose tangent is numeric_exp.
atan ( numeric_exp )
Returns the arctangent of the x and y coordinates specified by numeric_exp1 and numeric_exp2, respectively, in radians. The arctangent is the angle whose tangent is numeric_exp2 / numeric_exp1.
atan2 ( numeric_exp1 ,numeric_exp2 )
Returns the cosine of numeric_exp where numeric_exp is an angle expressed in radians.
cos ( numeric_exp )
Returns the hyperbolic cosine of numeric_exp where numeric_exp is an angle expressed in radians.
cosh ( numeric_exp )
Returns the sine of numeric_exp where numeric_exp is an angle expressed in radians.
sin ( numeric_exp )
Returns the hyperbolic sine of numeric_exp where numeric_exp is an angle expressed in radians.
sinh ( numeric_exp )
Returns the tangent of numeric_exp where numeric_exp is an angle expressed in radians.
tan ( numeric_exp )
Returns the hyperbolic tangent of numeric_exp where numeric_exp is an angle expressed in radians.
tanh ( numeric_exp )