Recently I had to check over and over again, if tables, which I needed for testing are existing in an Oracle database.
Since checking for existance and completion repeatedly involved the same tasks I decided to implement little PL SQL script, which does the task for me.
The script is searching in a system table for the given name of a table.
Table names are stored in capital characters in this table, which is why 'Upper()' is applied.
In case you want to check the existance of several tables you loop through a collection, as outlined in below example.