Answers for "open oracle using command"

SQL
0

oracle open for using

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  				-- open cursor variable
      'SELECT ename, sal FROM emp WHERE sal > :s' USING my_sal;
   ...
END;
Posted by: Guest on July-31-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language