Create a database table in Oracle. If this table exists, delete it and recreate it.

Instance:
Create a USERINFO database table:

Of course you can write it like this:
Drop table USERINFO
Create table USERINFO
(
EnglishName varchar (30 ),
ChineseName varchar (30 ),
Sex varchar (10 ),
Age int,
BirthPlace varchar (100 ),
BirthDate date default sysdate
)
However, there is a problem:
If USERINFO does not exist before, drop table USERINFO does not make any sense. Here there is one less if judgment. Well, let's see the correct solution:

Declare
W_count int;
W_name varchar (20 );
Begin
W_name: = 'userinfo ';
Select count (*) into w_count from user_tables where table_name = w_name;
If (w_count> 0) then
Execute immediate 'drop table userinfo ';
End if;
Execute immediate 'create table USERINFO
(
EnglishName varchar (30 ),
ChineseName varchar (30 ),
Sex varchar (10 ),
Age int,
BirthPlace varchar (100 ),
BirthDate date default sysdate
)';
End;

Save it as USERINFO. msql and execute it. Of course, you can also execute it in another way.