Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Verify if exist a table in a database
Message
From
02/09/2002 08:27:12
Christian Cote
Les Logiciels Onoma Inc.
Longueuil, Quebec, Canada
 
 
To
02/09/2002 00:28:28
Wilfred Chan
Bnp Paribas Hong Kong Branch
Hong Kong, Hong Kong
General information
Forum:
Oracle
Category:
Other
Title:
Re: Verify if exist a table in a database
Miscellaneous
Thread ID:
00695535
Message ID:
00695916
Views:
19
You can also use ALL_TABLES or USER_TABLES.

SELECT ... FROM ALL_TABLES WHERE TABLE_NAME = 'MyTableName';

HTH,
Christian
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform