FileDocCategorySizeDatePackage
SupportedScalarFunctions.javaAPI DocExample1552Thu Jun 14 17:53:14 BST 2001None

SupportedScalarFunctions

public class SupportedScalarFunctions extends Object

Fields Summary
Connection
conn
Constructors Summary
public SupportedScalarFunctions()

    try {
      DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
      conn = DriverManager.getConnection(
       "jdbc:oracle:thin:@dssw2k01:1521:orcl", "scott", "tiger");
    }
    catch (SQLException e) {
      System.err.println(e.getMessage());
      e.printStackTrace();
    }
  
Methods Summary
protected voidfinalize()

    if (conn != null) 
      try { conn.close(); } catch (SQLException ignore) { }
    super.finalize();
  
public static voidmain(java.lang.String[] args)

    SupportedScalarFunctions ssf = new SupportedScalarFunctions();

    ssf.process();  
  
public voidprocess()

    DatabaseMetaData dmd = null;
    try {
      dmd = conn.getMetaData();
      System.out.println("NUMERIC FUNCTIONS: ");
      System.out.println(dmd.getNumericFunctions());
      System.out.println(" ");
      System.out.println("STRING FUNCTIONS: ");
      System.out.println(dmd.getStringFunctions());
      System.out.println(" ");
      System.out.println("SYSTEM FUNCTIONS: ");
      System.out.println(dmd.getSystemFunctions());
      System.out.println(" ");
      System.out.println("TIME & DATE FUNCTIONS: ");
      System.out.println(dmd.getTimeDateFunctions());
    }
    catch (SQLException e) {
      System.err.println(e.getMessage());
    }