Answer to Question #258559 in Databases | SQL | Oracle | MS Access for Tarurendra Kushwah

Question

Write a block in PL/SQL to print the specific number of rows from a table.

Answer 1

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;
/