peate55的博客

存储过程的调用 1.增加,修改,删除的存储过程调用 create or replace procedure up_saveUserinfo as begin insert into userinfo values('qwert1','yuiop2'); commit; end; / 在这里执行用exec up_saveUserinfo;但在java里面一定要用{call up_saveU

1.查询出一行记录动态SQL create or replace procedure proc_insert ( id number ) as str_sql varchar2(500); mysal number; begin str_sql:='select sal from emp where empno = :1'; execute immediate str_sql into