There are several caveats in your code.
You don't need to select from dual, just check if "instr" returns 0 or not.
You don't need else and second if, use AND.
You have to take care of case. What if DROP COLUMN if written in capitals?