Oracle

Oracle Math
Oracle Trigonometry
add_months
Returns the datetime resulting from adding "integer_expression" months to "date_expression".
ascii
Returns a number representing the ASCII code value of the leftmost character of "string_expression".
ceil
Returns the smallest integer greater than or equal to "numeric_expression".
char_length
Returns the number of logical characters in "string_expression". The number of logical characters can be distinct from the number of bytes in some East Asian locales.
chr
Returns the character that has the ASCII code value specified by "integer_expression". "Integer_expression" should be between 0 and 255.
concat
Returns a string that is the result of concatenating, or joining, "string_expression1" to "string_expression2".
decode
Compares "expression" to each search value one by one. If "expression" is equal to a search, then it returns the corresponding result. If no match is found, it returns "default", or if "default" is omitted, it returns null.
dump
Returns internal representation of "expression" with the format of "numeric_expression1" starting from position "numeric_expression2" for "numeric_expression3" characters.
greatest
Returns the greatest value in "expression_list".
initcap
Returns "string_expression" with the first letter of each word in uppercase and all other letters in lowercase. Words are delimited by white space or characters that are not alphanumeric.
instr
Searches "string_expression1" starting at position "integer_expression1" for the "integer_expression2" occurrence of "string_expression2". If "integer_expression1" is negative, then the search occurs backwards from the end of "string_expression1". Returns an integer indicating the position of "string_expression2".
instrb
Searches "string_expression1" starting at position "integer_expression1" for the "integer_expression2" occurrence of "string_expression2". If "integer_expression1" is negative, then the search occurs backwards from the end of "string_expression1". Returns the position (byte number) where "string_expression2" was found.
least
Returns the least value in "expression_list".
length
Returns the number of characters in "string_expression".
lengthb
Returns the number of bytes in "string_expression".
lpad
Returns "string_expression1" left-padded to the length defined by "integer_expression" with occurrences of "string_expression2". If "string_expression1" is longer than "integer_expression", the appropriate portion of "string_expression1" is returned.
ltrim
Returns "string_expression1" with leading characters removed up to the first character not in "string_expression2".
months_between
Returns the number of months from "date_expression1" to "date_expression2". If "date_expression1" is later than "date_expression2" then the result will be a positive number. The days and time portion of the difference are ignored, so the months are not rounded unless "date_expression1" and "date_expression2" are the last days of a month.
new_time
Returns the datetime in "new_timezone" for "datetime_expression" in "old_timezone". "Old_timezone" and "new_timezone" can be one of 'AST', 'ADT', 'BST', 'BDT', 'CST', 'CDT', 'EST', 'EDT', 'HST', 'HDT', 'MST', 'MDT', 'NST', 'PST', 'PDT', 'YST', or 'YDT'.
next_day
Returns the datetime of the first weekday named by "string_expression" that is later than "datetime_expression". The return value has the same format as "datetime_expression".
nls_initcap
Returns "string_expression1" with the first letter of each word in uppercase and all other letters in lowercase. A word begins after any character other than a letter. Thus, in addition to a blank space, symbols such as commas, periods, and colons can introduce a new word. "String_expression2" specifies the sorting sequence.
nls_lower
Returns "string_expression1" with all letters in lowercase. "String_expression2" specifies the sorting sequence.
nls_upper
Returns "string_expression1" with all letters in uppercase. "String_expression2" specifies the sorting sequence.
nvl
Returns the value of "expression1" if "expression1" is not NULL. If "expression1" is NULL, then returns the value of "expression2".
replace
Replaces all occurrences of "string_expression2" in "string_expression1" with "string_expression3". If "string_expression3" is not specified, then it removes all occurrences of "string_expression2".
round
Returns "numeric_expression" rounded to the nearest value "integer_expression" places right of the decimal point. If "integer_expression" is negative, "numeric_expression" is rounded to the nearest absolute value "integer_expression" places to the left of the decimal point. Rounding takes place before data formatting is applied.
rpad
Returns "string_expression1" right-padded to length "integer_expression" with occurrences of "string_expression2". If "string_expression1" is longer than "integer_expression", the appropriate portion of "string_expression1" is returned. If "string_expression2" is not specified, then occurrences of "string_expression2" are replaced with spaces.
rtrim
Returns "string_expression1" with the final characters removed after the last character not in "string_expression2". If "string_expression2" is not specified, the final space characters are removed.
sign
Returns an indicator of the sign of "numeric_expression", +1 if positive, 0 if zero, or -1 if negative.
soundex
Returns a character string containing the phonetic representation of "string_expression".
substr
Returns the substring of "string_expression" that starts at position "integer_expression1" for "integer_expression2" characters or to the end of "string_expression" if "integer_expression2" is omitted. The first character in "string_expression" is at position 1.
substrb
Returns the substring of "string_expression" that starts at position "numeric_expression1" and ends after "numeric_expression2" bytes. The first byte in "string_expression" is at position 1. If you omit "numeric_expression2", returns the substring of "string_expression" that starts at position "numeric_expression1" and ends at the end of "string_expression".
{sysdate}
Returns a datetime value representing the current date and time of the computer that the database software runs on.
to_char
Returns the string representation of "expression" with the format of "string_expression". "Expression" can be either a date value or a numeric value.
to_date
Converts "expression1" to a datetime value as specified by the format "string_expression2". The first argument "expression1" may be of type string or numeric. "String_expression3" specifies the format elements, such as language.
to_number
Converts "string_expression1" to a numeric value as specified by the format "string_expression2". "String_expression3" specifies the format elements, such as currency information.
translate
Returns "string_expression1" with all occurrences of each character in "string_expression2" replaced by the corresponding character in "string_expression3".
trunc
Truncates "date_expression" using the format specified by "string_expression". For example, if "string_expression" is 'year', then "date_expression" is truncated to the first day of the year.
trunc
Truncates digits from "numeric_expression1" using "numeric_expression2" as the precision.
{user}
Returns the username of the current Oracle user.
vsize
Returns the number of bytes in the internal representation of "expression". "Expression" must be a string expression.

Parent topic: Using the expression editor