![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
丿贵族灬王爷
学习中随手笔记
展开
-
oracle中调用存储过程
存储过程的调用 1.增加,修改,删除的存储过程调用 create or replace procedure up_saveUserinfoasbegin insert into userinfo values('qwert1','yuiop2'); commit;end;/在这里执行用exec up_saveUserinfo;但在java里面一定要用{call up_saveU原创 2017-03-17 14:19:38 · 1190 阅读 · 0 评论 -
oracle中动态SQL的使用
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原创 2017-03-17 14:06:10 · 627 阅读 · 0 评论