Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: things I forgot or never knew
Mark Bole wrote:
> 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
I can easily make the same claim Tom made. Start off as ignorant as I am and you can learn a hundred new things each day ... if only I could remember a few of them the following week. ;-)
Things I have to relearn again and again:
ANY
SOME
THE
ALL
All the little things. ;-)
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Fri Aug 20 2004 - 21:06:25 CDT