e286. listing the numeric functions supported by a database.txt

来自「这里面包含了一百多个JAVA源文件」· 文本 代码 · 共 19 行

This example gets a list of numeric functions that a database supports. 
    try {
        DatabaseMetaData dbmd = connection.getMetaData();
    
        // Get the list of numeric functions
        String[] numericFunctions = dbmd.getNumericFunctions().split(",\\s*");
    } catch (SQLException e) {
    }

Examples in an Oracle database include: 
    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

Examples in a MySQL database include: 
    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