摘要:
摘要自 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_ 阅读全文