Can anyone point me to the right syntax to use in order to create a table only if it does not currently exist in the database?
I'm currently programming a Java GUI in order to connect to Oracle and execute statements on my database and I'm wondering if I would implement this as a Java constraint or a SQLPlus constraint.
Normally, it doesn't make a lot of sense to check whether a table exists or not because objects shouldn't be created at runtime and the application should know what objects were created at install time. If this is part of the installation, you should know what objects exist at any point in the process so you shouldn't need to check whether a table already exists.
If you really need to, however,
DBA_TABLESdepending on whether you are creating objects owned by other users and your privileges in the database) to check to see whether the table already exists.