Updating salary for different departments using cursor 1497 secret online dating guide only 5 copies for sale

declare Cursor Cur_ename is select empname,deptname from emp e,dept d where d.deptno = e.deptno; v_rec Cur_ename%rowtype; begin Open Cur_ename; loop Fetch Cur_ename into v_rec; exit when Cur_ename%notfound; dbms_output.put_line(‘Name –’

updating salary for different departments using cursor-52updating salary for different departments using cursor-12updating salary for different departments using cursor-1updating salary for different departments using cursor-31
TO_CHAR(SQL%ROWCOUNT)); END; / When you need precise control over query processing, you can explicitly declare a cursor in the declarative part of any PL/SQL block, subprogram, or package.For information on the use of PL/SQL records with SQL to update and insert data, see "Inserting PL/SQL Records into the Database" and "Updating the Database with PL/SQL Record Values".For additional information on assigning values to PL/SQL variables, see "Assigning a SQL Query Result to a PL/SQL Variable".

Leave a Reply