things I forgot or never knew

At a recent presentation by Tom Kyte (http://asktom.oracle.com) that I was able to attend, he mentioned that every day, he learns something new about Oracle.

While I am nowhere close to being able to make that claim, lately I've been reminded of the following. What's your list?

analytic functions ( select row_number() over ( partition by....) )

extract function

isolation level serializable

dbms_random

dbms_support

DBMS_XPLAN archive_log_lag

in-line select queries (aka Scalar Subquery Expressions) (a long-time feature of SQL Server...)

--Mark Bole Received on Thu Aug 19 2004 - 22:12:20 CDT