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;