CREATE TABLE plch_data (n NUMBER)Table created.
BEGIN
INSERT INTO plch_data
VALUES (100);
COMMIT;
END;1 row(s) inserted.
CREATE OR REPLACE PROCEDURE plch_show_count
IS
l_count INTEGER;
BEGIN
SELECT COUNT (*) INTO l_count FROM plch_data;
DBMS_OUTPUT.put_line ('Count=' || l_count);
END;Procedure created.
DECLARE
l_count INTEGER;
BEGIN
DELETE FROM plch_data;
EXECUTE IMMEDIATE 'create table plch_data (n number)';
plch_show_count;
EXCEPTION
WHEN OTHERS
THEN
plch_show_count;
END;Count=0
DECLARE
l_count INTEGER;
BEGIN
DELETE FROM plch_data;
EXECUTE IMMEDIATE 'create table plch_data2 (n number)';
plch_show_count;
EXCEPTION
WHEN OTHERS
THEN
plch_show_count;
END;Count=0
DECLARE
l_count INTEGER;
BEGIN
DELETE FROM plch_data;
EXECUTE IMMEDIATE 'create table plch_data (n number)';
ROLLBACK;
plch_show_count;
EXCEPTION
WHEN OTHERS
THEN
ROLLBACK;
plch_show_count;
END;Count=0
DROP TABLE plch_data2Table dropped.
DECLARE
l_count INTEGER;
BEGIN
DELETE FROM plch_data;
EXECUTE IMMEDIATE 'create table plch_data2 (n number)';
ROLLBACK;
plch_show_count;
EXCEPTION
WHEN OTHERS
THEN
ROLLBACK;
plch_show_count;
END;Count=0
DROP TABLE plch_data2Table dropped.
DROP TABLE plch_dataTable dropped.
DROP PROCEDURE plch_show_countProcedure dropped.