Postgresql, Autocommit, Oracle.
committed is visible: sqlplus demo/demo@//localhost/PDB1 ### Oracle Database 19.4 column t format a35 exec for i in (select table_name from user_tables where table_name='DEMO') loop execute immediate 'drop table "'||i.table_name||'" cascade constraints'; end loop; create table DEMO as select 1