String Expression Functions

FDO API

Numeric Expression Functions

Expression Function List

String Expression Functions

The following string expression functions are supported:

The function Translate does not translate a string from one character set to a different one. Instead, it just replaces a set of letters in a string with their corresponding replacement characters where each character specified in the set of characters to be replaced is replaced by the character in the set of replacement characters at the same place. For example, if the call is Translate(‘’SQL*Plus User’’s Guide’, ‘ */’’’, ‘---‘), each of the specified characters in the first set will be replaced by the character in the same position in the second set. In this example, the resulting string will be SQL_Plus_Users_Guide because:

Any space will be replaced by a _
Any * will be replaced by a _
Any / will be replaced by a _ (in this case, nothing will be done because the string does not include the specified character)
Any ’ will be removed because there is no corresponding replacement character specified.

Function Name	Description
Concat	Returns the concatenation of two string expressions.
Instr	Returns the position of a substring in a string expression.
Length	Returns the length of a string expression.
Lower	Converts all uppercase letters in a string expression into lowercase letters.
Lpad	Pads a string expression to the left to a predefined string length.
Ltrim	Removes leading blanks from a string expression.
Rpad	Pads a string expression to the right to a predefined string length.
Rtrim	Removes trailing blanks from a string expression.
Soundex	Returns the phonetic representation of a string expression.
Substr	Extracts a substring from a string expression.
Translate	Replaces a set of letters in a string.
Trim	Removes leading and/or trailing blanks from a string expression.
Upper	Converts all lowercase letters in a string expression into uppercase letters.
Table 7: List of numeric expression functions

previous page start