oracle存储过程
柔软时光
这个作者很懒,什么都没留下…
展开
-
几个oracle 存储过程的例子
create or replace procedure p_ts_print_asset_v_manage as v_depth integer :=44; v_out integer; begin dbms_output.put_line('ssss'); p_ts_print(v_depth,v_out); dbms_output.put_line(v原创 2015-06-17 13:37:45 · 264 阅读 · 0 评论 -
plsql语句块 for 遍历游标
declare cursor cur_quick_info is select * from ewallet.t_quick_pay_info where status='S' and pay_channel='01001906' and outer_merchant_id='1217015601' and quick_pay_id='201501010010KJ07289原创 2016-03-13 22:42:41 · 2138 阅读 · 0 评论