Re: should one use ANSI join syntax when writing an Oracle application?

I find that it helps to think of the analytic functions as a presentation layer added into the SQL.

First write the SQL to acquire the data and aggregate it to produce the correct result set.

Then add analytic columns which add value to the data. Then optionally use some analytic results to reduce the output again.

Regards

Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

• Original Message ----- From: "Polarski, Bernard" <Bernard.Polarski_at_atosorigin.com>

Having said that, the last tendency of analytic function violate 100% the philosophy of SQL
which was keep the syntax simple and leave difficulty on the action performed. Now if I don't practise the rollup, I tend to forget the syntax.

--

http://www.freelists.org/webpage/oracle-l Received on Tue Oct 17 2006 - 08:44:29 CDT