Get list of stored procedure names : Oracle « Database « Java Tutorial

1. Java Tutorial
2. Database
3. Oracle

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;

public class Main {
  private static String url = "jdbc:oracle:thin:@localhost:1521:javaDemo";

  private static String username = "java";

  private static String password = "";

  public static void main(String[] args) throws Exception {
    Class.forName("oracle.jdbc.driver.OracleDriver");
    Connection conn = DriverManager.getConnection(url, username, password);

    DatabaseMetaData metadata = conn.getMetaData();
    ResultSet result = metadata.getProcedures(null, "JAVA", "%");
    while (result.next()) {
      System.out.println(result.getString("PROCEDURE_CAT") + " - "
          + result.getString("PROCEDURE_SCHEM") + " - " + result.getString("PROCEDURE_NAME"));
    }
  }
}