摘要: 摘要自 Oracle性能控制艺术DECLARE l_ename emp.ename%TYPE :='SCOTT'; l_empno emp.empno%TYPE; l_cursor INTEGER; l_retval INTEGER;BEGIN l_cursor:=dbms_sql.open_cursor; dbms_sql.parse(1_cursor,'SELECT empno FROM emp WHERE ename=:ename',1); dbms_sql.define_column(l_cursor,1,l_empno); dbms_sql.bind_ 阅读全文
posted @ 2014-01-15 09:44 健哥的数据花园 阅读(199) 评论(0) 推荐(0) 编辑