Set of values:
Maximum
Selects the maximum value of a set of values
Date:
Day:
NextDay
Returns the date of the first weekday named with 'Day' and follows with the 'Date'
String1:
String2:
Concat
Concatenates two character strings
Value:
ArcCosine
Returns the arc cosine of a numerical expression
Character string:
Search:
Locate
Returns the position of a character in a character string
Angle:
Tangent
Returns the tangent of an angle
Value:
Divided by:
Mod
Returns the remainder of a division
Value:
Arc tangent
Returns the arc tangent of a numerical expression
Value:
Exp
Returns the exponential value of the specified value
Angle:
Sine
Returns the sine of an angle
Character string:
Rtrim
Removes blank characters from the right of a character string
Character string:
Lowercase
Returns a character string in lower case
Character string:
LeftRemove
Removes blank characters from the left of a character string
Set of values:
Sum
Returns the sum of the values
Object1:
Object2:
Date NVL
If Object1 is null, returns Object2. If Object1 is not null, returns Object1
Numerical expression:
Floor
Returns the value of a number rounded down to the nearest integer
Set of values:
Average
Returns the average value of a set of values
ASCII code:
Character
Returns the character that corresponds to the ASCII code
Character string:
Length:
Left
Returns a specified number of characters from the left of a character string
Question:
Numeric Prompt
Prompts the user to enter a specific value
Value:
ToChar
Converts a value into a character string
Value:
Random
Returns a random number between 0 and 1
Question:
Character Prompt
Prompts the user to enter a specific value
Value:
ArcSine
Returns the arc sine of a numerical expression
Date:
Last Day
Returns the last day of the month of a defined date
Numerical expression:
Ceil
Returns the value of a number rounded up to the nearest integer
Expression:
Number of times:
Repeat
Repeats a character expression n number of times
Numerical expression:
Absolute
Returns the absolute value of a number
Character string:
Number of characters to extract:
Rightpart
Returns a specified number of characters from the right of a character string
Character string:
Initial position:
Number of characters:
Substring
Extracts a sequence of characters from a character string
Character string:
Uppercase
Returns a character string in upper case
Value:
Log
Returns the natural logarithm of the specified value
Object 1:
Object 2:
Numeric NVL
If Object1 is null, returns Object2. If Object1 is not null, returns Object1
Date:
Number of months:
Add Months
Adds a number of months to a date
Object1:
Object2:
Character NVL
If Object1 is null, returns Object2. If Object1 is not null, returns Object1
Question:
Date Prompt
Prompts you to enter a specific date
First argument:
Second argument:
If Null
Returns the first argument if it is not null, the second otherwise
Angle1:
Angle2:
AngleTangent2
Returns the angle in radians whose tangent is Angle1/Angle2
Character string:
Format:
ToDate
Converts a character string into a date
Character string:
Length
Returns the length of a character string
Date:
DateToChar
Converts a date into a character string
Character:
ASCII Code
Returns the ASCII code of a character
Pi
Returns the constant value of 3.1415926535897932
Number:
Sqrt
Returns the square root of a number
Set of values:
Count
Counts the number of entries
Set of values:
Minimum
Selects the minimum value of a set of values
Value:
Sign
Returns a number that represents the sign of the specified number
Angle:
Cosine
Returns the cosine of an angle