Listing the String Functions Supported by a Database
This example retrieves a list of string functions that a database
supports.
Examples in an Oracle database include:
Examples in a MySQL database include:
try {
DatabaseMetaData dbmd = connection.getMetaData();
// Get the list of string functions
String[] stringFunctions = dbmd.getStringFunctions().split(",\\s*");
} catch (SQLException e) {
}
CHR, INITCAP, LOWER, LPAD, LTRIM, NLS,_INITCAP, NLS,_LOWER, NLS,_UPPER,
REPLACE, RPAD, RTRIM, SOUNDEX, SUBSTR, SUBSTRB, TRANSLATE, UPPER, ASCII,
INSTR, INSTRB, LENGTH, LENGTHB, NLSSORT, CHARTOROWID, CONVERT, HEXTORAW,
RAWTOHEX, ROWIDTOCHAR, TO_CHAR, TO_DATE, TO_LABEL, TO_MULTI_BYTE,
TO_NUMBER, TO_SINGLE_BYTE
ACII,CHAR,CHAR_LENGTH,CHARACTER_LENGTH,CONCAT,ELT,FIELD,FIND_IN_SET,
INSERT,INSTR,INTERVAL,LCASE,LEFT,LENGTH,LOCATE,LOWER,LTRIM,MID,POSITION,
OCTET_LENGTH,REPEAT,REPLACE,REVERSE,RIGHT,RTRIM,SPACE,SOUNDEX,SUBSTRING,
SUBSTRING_INDEX,TRIM,UCASE,UPPER
Good example.