do we have if/then/else in sqlplus?

[miritika]

if u connect as scott then it gives u an error insufficient priveleges.

So u just need to login as sys and issue this command

grant create table to scott;

But if u r logged in as sys user then it gives no problem. It has been tested.