If you delete a collection, you delete the collection and all of its members, for example:
HTMLDB_COLLECTION.DELETE_COLLECTION (
p_collection_name => collection name );
Be aware that if you do not delete a collection, it will eventually be deleted when the session is purged. For example:
Deleting All Collections for the Current Application
Use the DELETE_ALL_COLLECTIONS method to delete all collections defined in the current application, for example:
HTMLDB_COLLECTION.DELETE_ALL_COLLECTIONS;
Deleting All Collections in the Current Session
Use the DELETE_ALL_COLLECTIONS_SESSION method to delete all collections defined in the current session., for example:
HTMLDB_COLLECTION.DELETE_ALL_COLLECTIONS_SESSION;
