Q:

Write a program in PL/SQL to find the number of rows effected by the use of SQL%ROWCOUNT attributes of an implicit cursor

0

Write a program in PL/SQL to find the number of rows effected by the use of SQL%ROWCOUNT attributes of an implicit cursor.

All Answers

need an explanation for this answer? contact us directly to get an explanation for this answer

DROP TABLE emp_temp;
CREATE TABLE emp_temp AS
  SELECT employee_id, first_name, last_name,email 
  FROM employees;

BEGIN
    UPDATE emp_temp
    SET    email = 'not available'
    WHERE  first_name LIKE 'B%';

    dbms_output.Put_line('Number of record updated: '
                         ||To_char(SQL%rowcount));
END;
/
 Sample Output:
Number of record updated: 2

PL/SQL procedure successfully completed.

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

Similar questions


need a help?


find thousands of online teachers now