CREATE TABLE employees
AS
   SELECT * FROM hr.employees

Impact of First DML Sticks Around

DECLARE
   l_count   PLS_INTEGER;
BEGIN
   SELECT COUNT (*)
     INTO l_count
     FROM employees
    WHERE salary = 10000;

   DBMS_OUTPUT.put_line ('Count=' || l_count);

   /* No problem here. */
   UPDATE employees
      SET salary = 10000;

   BEGIN
      UPDATE employees
         SET last_name = RPAD (last_name, 10000, '*');
   EXCEPTION
      WHEN OTHERS
      THEN
         DBMS_OUTPUT.put_line (SQLERRM);
   END;

   SELECT COUNT (*)
     INTO l_count
     FROM employees
    WHERE salary = 10000;

   DBMS_OUTPUT.put_line ('Count=' || l_count);
END;