declare tableCount number; begin select count(*) into tableCount from user_all_tables where table_name = 'STUDENT'; if tableCount > 0 then execute immediate 'drop table STUDENT'; end if; execute immediate 'create table student ( id integer, stuName varchar2(20), primary key(id) )'; end;