Character functions
It takes character arguments. Some returns character values others return numeric values.
ASCII Ascii function (char VARCHAR2) return NUMBER Returns the collating code that represents the character char in the database character set. ASCII (d) gives 100.
Char function CHAR (nom NUMBER) return VARCHAR2 Returns the character in the database character set that the collating code num represents.
Concat function CONCAT (str1 VARCHAR2, str2 VARCHAR2) return VARCHAR2
Appends string str2 to string str1 and then returns the combined string, if either argument is NULL CONCAT returns the other.
Lower
function LOWER (str CHAR) return CHAR Returns the string str with all letters in lowercase. Similarly the UPPER function returns all letters in uppercase.
Length
function LENGTH (str CHAR) returns NUMBER
Returns the number of characters in string str. Similarly the function LENGTHB returns the number of bytes in the string str.
Domain Name Search
|
