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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only