Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can I check is a table object exist ?
Message
From
04/10/2001 00:17:33
Wilfred Chan
Bnp Paribas Hong Kong Branch
Hong Kong, Hong Kong
 
 
To
03/10/2001 14:35:56
General information
Forum:
Oracle
Category:
PL/SQL
Miscellaneous
Thread ID:
00563779
Message ID:
00563978
Views:
20
You can try this:
..

Cursor delete_table IS
select object_name from user_objects
where object_name="xxxxx"
and object_type="TABLE"
...

Fetch delete_table INTO to_be_del;
IF to_be_del%NOTFOUND THEN
EXIT
...
...
Previous
Reply
Map
View

Click here to load this message in the networking platform