Answers for "oracle execute immediate cursor loop example"

SQL

0

oracle execute immediate cursor loop example

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

Source

Code answers related to "oracle execute immediate cursor loop example"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#