Listing the Numeric Functions Supported by a Database
This example gets a list of numeric 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 numeric functions
String[] numericFunctions = dbmd.getNumericFunctions().split(",\\s*");
} catch (SQLException e) {
}
ABS, CEIL, COS, COSH, EXP, FLOOR, LN, LOG, MOD, POWER, ROUND, SIGN, SIN, SINH,
SQRT, TAN, TANH, TRUNC, AVG, COUNT, GLB, LUB, MAX, MIN, STDDEV, SUM, VARIANCE
ABS,ACOS,ASIN,ATAN,ATAN2,BIT_COUNT,CEILING,COS,COT,DEGREES,EXP,
FLOOR,LOG,LOG10,MAX,MIN,MOD,PI,POW,POWER,RADIANS,RAND,ROUND,SIN,
SQRT,TAN,TRUNCATE
Post a comment