Page Comparison

...

The only practical way of doing the first two above is to take the process in two stages:
Stage 1. The first stage selects from the USER_OBJECTS table along with strings that will later be used as SQL:

select 'drop '||object_type||object_name||';' from USER_OBJECTS;

row returned, example-> drop TABLE SAKAI_USER;

Stage 2. the second stage is to run the script generated from stage 1

The method for doing the varies a little based on the client used. There is room below for adding scripts for this for various clients.

...