HELP: Why doesn't this query work?

Hi, yes, I'm an Oracle newbie:

When I run this query:

declare
thecount number ;

begin  

select count(*) into thecount from user_tables where table_name = 'B'; if thecount = 0 then

                   create table B (theCol number);
end if;
end;

I get this error:

PLS-00103: Støtte på symbolet CREATE der ett av følgende var ventet: ....blah blah...

why is this? When I change the statement in the "IF" block to..say..an Insert statement it works ok...

HELP! Thank you Received on Thu Feb 12 2004 - 05:40:41 CST