Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: things I forgot or never knew

Re: things I forgot or never knew

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 20 Aug 2004 19:06:25 -0700
Message-ID: <1093054034.669725@yasure>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US