Introduced with Oracle 10gR2, DML Error Logging allows you to make standard SQL INSERT, UPDATE, and MERGE statements behave more like the SQL*Loader utility, logging errors to a table rather than failing and rolling back the first time an error condition is encountered.
At this year’s HOTSOS Symposium Tanel Poder presented a training day that really highlighted some very practical ways to tailor your environment so that common tasks will be easier. One tip that I have really appreciated is how to use the Unix/Linux package rlwrap (readline wrapper). Using this with a few parameters and in conjunction with SQL*Plus makes a huge difference. It is now possible to have a command history and tab-enabled auto-completion of keywords available in SQL*Plus.