
Table dropped.
Table created.
1 row created.
1 row created.
1 row created.
1 row created.

Table dropped.
Table created.
Table dropped.
Table created.

[temp COALESCE] Elapsed Time  : 5 hundredths of a second.
 
PL/SQL procedure successfully completed.
 
ORIGINAL TABLE
--------------
 
    SALARY STARTDATE STOP
---------- --------- ---------
     60000 01-JAN-95 01-JUN-95
     70000 01-JUN-95 01-OCT-95
     70000 01-OCT-95 01-FEB-96
     70000 01-FEB-96 01-JAN-97
 

OUTPUT TABLE (AFTER COALESCING)
-------------------------------
 
    SALARY STARTDATE ENDDATE
---------- --------- ---------
     60000 01-JAN-95 01-JUN-95
     70000 01-JUN-95 01-JAN-97
 
