WORA Oracle Datatypes


CHAR
String of characters, up to 255

List of Functions for CHAR Datatype

LOWER
to lower case
UPPER
to upper case
LENGTH
length of the character string
COUNT,
number of records, group function
MIN
minimum - e.g. 'A' less than 'B', 'abc' less than 'ab', group function
MAX
maximum, group function

List of Operators for CHAR Datatype

=
equal to
!=
not equal to
<
less then
>
greater then
LIKE
1-st argument contains 2-nd as a substring
NOT LIKE
1-st argument doesn't contain 2-nd as a substring
NULL
Field is empty
NOT NULL
Field is not empty
NUMBER
Number, practically enough of them for any reasonable human being

List of Functions for NUMBER Datatype

ABS
Absolute value
ROUND
Rounded value
SIGN
equals 1 when argument positive, -1 otherwise
SQRT
Square root
COUNT, MIN, MAX, group functions
The same as for CHAR
AVG, STDDEV
Average and standard deviation accordingly, group function
SUM
guess, what is it ?

List of Operators for NUMBER Datatype


ocr