aldovalerio
Programmer
(Oracle 8.1.7) Is there any performance difference between the following two code examples? Are they both actually binding the my_sal variable? Apart from performance, is there any reason to choose one method over the other?
-- Option #1
DECLARE
TYPE EmpCurTyp IS REF CURSOR; -- define weak REF CURSOR type
emp_cv EmpCurTyp; -- declare cursor variable
my_ename VARCHAR2(15);
my_sal NUMBER := 1000;
BEGIN
OPEN emp_cv FOR
'SELECT ename, sal FROM emp WHERE sal > :s'
USING my_sal;
...
END;
-- Option #2
DECLARE
TYPE EmpCurTyp IS REF CURSOR; -- define weak REF CURSOR type
emp_cv EmpCurTyp; -- declare cursor variable
my_ename VARCHAR2(15);
my_sal NUMBER := 1000;
BEGIN
OPEN emp_cv FOR
SELECT ename, sal FROM emp WHERE sal > my_sal;
...
END;
-- Option #1
DECLARE
TYPE EmpCurTyp IS REF CURSOR; -- define weak REF CURSOR type
emp_cv EmpCurTyp; -- declare cursor variable
my_ename VARCHAR2(15);
my_sal NUMBER := 1000;
BEGIN
OPEN emp_cv FOR
'SELECT ename, sal FROM emp WHERE sal > :s'
USING my_sal;
...
END;
-- Option #2
DECLARE
TYPE EmpCurTyp IS REF CURSOR; -- define weak REF CURSOR type
emp_cv EmpCurTyp; -- declare cursor variable
my_ename VARCHAR2(15);
my_sal NUMBER := 1000;
BEGIN
OPEN emp_cv FOR
SELECT ename, sal FROM emp WHERE sal > my_sal;
...
END;