PL/sql 如何执行语句块?

发布网友发布时间：2022-04-07 16:07

共4个回答

懂视网时间：2022-04-07 20:29

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); } }

输出：

http://stackoverflow.com/questions/6214172/pl-sql-call-from-jdbc-resulting-in-sqlsyntaxerrorexception-ora-00900/6214370#6214370

执行Sql块

标签：

热心网友时间：2022-04-07 17:37

打开一个command windows，中文大概叫命令窗口
点击窗口左上角的Editor，中文版可能叫编辑器，
粘贴进去，点执行即可
另外记得在语句块下面加个/

热心网友时间：2022-04-07 18:55

存储过程
create or replace procere test is
v_id number;
begin
v_id:=1;
for v_id in 1..15 loop
insert into temp_tab values( v_id);
end loop;
end test;

热心网友时间：2022-04-07 20:29

使用function追问麻烦详细点，谢谢！