I need to check if a table exisits and drop it if it does (without errors) so a DROP and error if it doesn't exist won't work.
DROP TABLE IF EXITS <tablename>;
(I know you Oracle guys will probably want me put down for writing a MySQL command in here, but hey!)
doesnt exist in Oracle, so is there a fancy way so I can get a yes/ no answer back into a variable in Perl to do an IF in perl? or even better a fancy way of doing this direct in Oracle?