![]() |
The Java Developers Almanac 1.4Order this book from Amazon. |
e287. Listing the System Functions Supported by a DatabaseThis 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, VSIZEExamples in a MySQL database include: DUMP, GREATEST, GREATEST_LB, LEAST, LEAST_UB, NVL, UID, USER, USERENV, VSIZE
e285. Listing the String Functions Supported by a Database e286. Listing the Numeric Functions Supported by a Database e288. Listing the Time and Date Functions Supported by a Database e289. Getting the Maximum Table Name Length in a Database e290. Listing Available SQL Types Used by a Database e291. Getting the Name of a JDBC Type © 2002 Addison-Wesley. |