Here is the Tom Kyte thread that talks about differences a bit with demos:

http://asktom.oracle.com/pls/ask/f?p...0_P8_DISPLAYID,F4950_P8_CRITERIA:735625536552,%7Banalyze%7D

[Edited by sreddy on 10-08-2002 at 10:17 AM]