Corporation Video Gaming Accessories User Manual

Supported Functions
D-2 Oracle Application Server Adapters for IMS/DB User's Guide
Supported Functions
OracleAS Adapter for IMS/DB enables the use of the following functions in SQL
statements:
■ String Functions
■ Group Functions
■ Mathematical Functions
>
<
>=
<=
<>, !=, ^=
IS NOT NULL
IS NULL
Table D–3 String Functions
Oracle
Function
Oracle Connect
Function Usage Comment
|| || str1 || str2 Returns a string consisting of str1 concatenated with str2
Ascii Ascii Ascii(c) Returns the ASCII value of c
Chr Chr Chr(ascii) Returns the character corresponding to the given ASCII value
Instr Position Position(str2, str1) Returns an index in str2 to the first occurrence of str1 in str2
Length Length Length(str) Returns the number of bytes of str
Lower Lower Lower(str)Returns str in lowercase
Lpad Lpad Lpad(str, n)Returns str with n leading blanks
Ltrim Ltrim Ltrim(str)Returns str with leading blanks removed
Rpad Rpad Rpad(str, n)Returns str with n trailing blanks
Rtrim Rtrim Rtrim(str)Returns str with trailing blanks removed
Substr Substr Substr(str, n [, m]) Returns a substring of str, starting with the nth character and
m characters in length, or until the end of the string if m is not
supplied
Upper Upper Upper(str)Returns str in uppercase
Table D–4 Group Functions
Oracle
Function
Oracle Connect
Function Usage Comment
Avg Avg Avg(
exp) Returns the average value of the expression exp
Count Count Count(exp) Returns the count of the expression exp
Table D–2 (Cont.) Comparison Operators
Operator