Write a program in PL/SQL to find the number of rows effected by the use of SQL%ROWCOUNT attributes of an implicit cursor
- pl/sql
- 2021-09-28
- mhanasmh00489829403
الأجوبة
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.
أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال
معلومات ذات صلة