Re: getting the nearest number from a column

On Apr 10, 7:39 pm, Mladen Gogala <mgogala.SPAM-ME...._at_verizon.net> wrote:
> Find me a mention that this is a windowing function:http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/
> functions087.htm#i1280029

In the above mentioned doco i.e.
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/functions087.htm#i1280029 you can read
"See Also:
"Analytic Functions" for information on syntax, semantics, and restrictions" that forwards you to
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/functions001.htm#i81407 There you immediately can find that windowing clause is optional by reading the syntax diagramm.
A bit below you'll find following text:
"windowing_clause
Some analytic functions allow the windowing_clause. In the listing of analytic functions at the end of this section, the functions that allow the windowing_clause are followed by an asterisk (*)." MIN definitely has this asterisk.
And some rows below you'll find also following text: "If you omit the windowing_clause entirely, then the default is RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW." And now some more comments:
1) if you think that documentation is bad/unclear you can go to http://forums.oracle.com/forums/forum.jspa?forumID=165 and express your thoughts
2) it would be rather strange if everything that concerns each analytic function would be written for each function. The same is also relevant for example to aggregate functions including MIN that forwards you to http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/functions001.htm#i89203 I think you also in your databases create classifiers (analogy - analytic function descriptions) and use foreign keys (analogy - links to it) to descibe some value only in one place. 3) obviously you have reached your highest level of documentation understanding here, not surprise that other people might reach it some steps before you ;)

Gints Plivna
http://www.gplivna.eu Received on Tue Apr 10 2007 - 15:55:53 CDT