e287. listing the system functions supported by a database.txt

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

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

Examples in an Oracle database include: 
    DUMP, GREATEST, GREATEST_LB, LEAST, LEAST_UB, NVL, UID, USER, USERENV, VSIZE

Examples in a MySQL database include: 
    DUMP, GREATEST, GREATEST_LB, LEAST, LEAST_UB, NVL, UID, USER, USERENV, VSIZE