Listing the System Functions Supported by a Database
This example gets a list of system 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 system functions
String[] systemFunctions = dbmd.getSystemFunctions().split(",\\s*");
} catch (SQLException e) {
}
DUMP, GREATEST, GREATEST_LB, LEAST, LEAST_UB, NVL, UID, USER, USERENV, VSIZE
DUMP, GREATEST, GREATEST_LB, LEAST, LEAST_UB, NVL, UID, USER, USERENV, VSIZE
Post a comment