Using PL/SQL you can select by PK with rownum < 2 and just catch an
exception.
-Original Message-
Sent: Monday, May 21, 2001 11:51 AM
To: Multiple recipients of list ORACLE-L
Is it possible to check if a table first exist so I do not
get any error messages on my installation scripts?
Two ways to handle this in an installer:
1. Build everything in dependency order. This can be a pain because it
tends to change any time the schema is touched.
2. Create everything (specify "force" on indexes) ignoring the errors.
Spool them to a file and turn termout off if you don't want the