DECLARE
	row_count INTEGER := 0;
	table_has_more_than_0_rows EXCEPTION;

BEGIN
	/* Create table but don't add any rows to it. Note "EXECUTE IMMEDIATE"
         must be used for DDL statements within PL/SQL code.  */
	EXECUTE IMMEDIATE 'CREATE TABLE my_table (my_int INTEGER)';

	/* Select # of rows (which will be zero) from new table and store in row_count. */
	EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM my_table' INTO row_count;
	DBMS_OUTPUT.PUT_LINE('Table has this many rows: '||row_count);
	COMMIT;

	DBMS_OUTPUT.PUT_LINE('');
	DBMS_OUTPUT.PUT_LINE('Inserting 3 rows into table...');
	EXECUTE IMMEDIATE 'INSERT INTO my_table VALUES(1)';
	EXECUTE IMMEDIATE 'INSERT INTO my_table VALUES(2)';
	EXECUTE IMMEDIATE 'INSERT INTO my_table VALUES(3)';
	EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM my_table' INTO row_count;
	DBMS_OUTPUT.PUT_LINE('Table has this many rows: '||row_count);

	/* Throw exception if # of rows is more than 0. */
	IF row_count>0 THEN
		RAISE table_has_more_than_0_rows;	
	END IF;

	EXECUTE IMMEDIATE 'DROP TABLE my_table';

EXCEPTION
	/* Handle exceptions. */
	WHEN table_has_more_than_0_rows THEN
		DBMS_OUTPUT.PUT_LINE('');
		DBMS_OUTPUT.PUT_LINE('Attempting to rollback to 0 rows...');
		ROLLBACK;
		COMMIT;
		DBMS_OUTPUT.PUT_LINE('Table has this many rows: '||row_count);
		EXECUTE IMMEDIATE 'DROP TABLE my_table';

	WHEN OTHERS THEN
		DBMS_OUTPUT.PUT_LINE('Some unknown exception was caught.');
		EXECUTE IMMEDIATE 'DROP TABLE my_table';


END;
.
run;

SQL> create table faq (id number);

Table created.

SQL> insert into faq values (1);

1 row created.

SQL> begin
  2    execute immediate('insert into faq values(2)');
  3  end;
  4  /

PL/SQL procedure successfully completed.

SQL> select * from faq;

        ID
----------
         1
         2