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
- The same as for CHAR, excluding LIKE and NOT LIKE
ocr