Tom Kyte's seminar, Day 2

I got so excited about ORADEBUG feature I described in the previous post that completely forgot to mention the main news of the day - the second day of Tom's seminar. It was an excellent day packed with lot of useful tricks and tips plus I cleaned quite a few things in my mind. The best one that I got straight now - so called "Write Consistency" in Tom's terms.

Small but neat 10g R2 feature:

SQL> SET SERVEROUTPUT ON SIZE UNLIMITED

I can also put up to 32K lines using DBMS_OUTPUT.PUT_LINE. No comments.

And by the way, Tom's story with Best Buy was real as he mentioned today.