摘要: create or replace procedure pro_cursor_type_Vast_tmp table3%rowtype;type c_type is ref cursor;cur c_type; v_taname varchar2(100);beginv_taname:='aa';open cur for 'select * from table3 where taname=:a order by taid desc' --a只是绑定变量的占位符以 =: 符号进行绑定 using v_taname; dbms_output.put_line(&# 阅读全文
posted @ 2012-06-21 19:10 blog_yuan 阅读(435) 评论(0) 推荐(0) 编辑