输出：
1
http://stackoverflow.com/questions/6214172/pl-sql-call-from-jdbc-resulting-in-sqlsyntaxerrorexception-ora-00900/6214370#6214370
执行Sql块
标签：
声明：本文来自网络，不代表【好得很程序员自学网】立场，转载请注明出处：http://haodehen.cn/did118673
执行Sql块
java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import oracle.ConnectionManager;
import oracle.exception.GetConnectionException;
public class JDBC_EXEC {
public static void main(String[] args) throws SQLException, GetConnectionException {
String ip ="ip" ;
String user ="user" ;
String password ="pwd" ;
String instanceName ="orcl" ;
ConnectionManager cm = new ConnectionManager(ip,instanceName,user,password);
Connection conn = cm.getOracleConnection();
String sql ="begin"+
" dbms_stats.gather_table_stats(ownname => ‘user‘,"+
" tabname => ‘tableName,"+
" estimate_percent => null,"+
" method_opt => ‘for all indexed columns‘,"+
" cascade => true);"+
" end;" ;
Statement cs = conn.createStatement();
System.out.println(cs.executeUpdate(sql));
cm.close(cs);
cm.close(conn);
}
}
阅读：34次