Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Dynamic SQL newbee question
Hello gurus,
I am new with dynamic SQL. Will you explain how following example works.
EXEC SQL PREPARE my_statement FROM :my_string; EXEC SQL DECLARE emp_cursor
FOR SELECT empno, ename, sal, comm FROM emp WHERE deptno = :dept_number EXEC SQL DESCRIBE BIND VARIABLES FOR my_statement INTO bind_descriptor; EXEC SQL OPEN emp_cursor USING bind_descriptor; EXEC SQL DESCRIBE SELECT LIST FOR my_statement INTO select_descriptor; EXEC SQL FETCH emp_cursor INTO select_descriptor;
Thanx in advance.
Rajesh
Received on Fri Nov 13 1998 - 07:03:46 CST