tag:blogger.com,1999:blog-2132893136140848212.post8480074675922365568..comments2023-09-09T03:03:30.219-06:00Comments on Martin Giffy D'Souza on Oracle APEX: Some Interesting Oracle Analytic FunctionsMartin D'Souzahttp://www.blogger.com/profile/06992954599899886499noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-2132893136140848212.post-13158709939008187042014-04-12T21:47:02.413-06:002014-04-12T21:47:02.413-06:00Hi Rick,
Excellent question. Long story short, th...Hi Rick,<br /><br />Excellent question. Long story short, the same salary can exist in two buckets because of how Oracle "buckets data". I've written a follow up article detailing this: http://www.talkapex.com/2014/04/ntile-vs-widthbucket.html I've also updated the NTILE notes referencing that article in case anyone else has the same question.<br /><br />MartinMartin D'Souzahttps://www.blogger.com/profile/06992954599899886499noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-4929443512800986472014-04-11T18:02:44.215-06:002014-04-11T18:02:44.215-06:00Hi Martin
It is probably my misunderstanding. In t...Hi Martin<br />It is probably my misunderstanding. In the ex. Pertaining to salaries in the 3 buckets I was curious how the salary 1250 is in both buckets 2 and 3. It is probably just a function of sorted 15 rows / 3Anonymoushttps://www.blogger.com/profile/01325873444964000691noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-66045168894983926792014-04-11T14:40:48.895-06:002014-04-11T14:40:48.895-06:00Hi Rick,
I'm not sure what your question is r...Hi Rick,<br /><br />I'm not sure what your question is regarding the two different buckets. Can you please be more specific.<br /><br />MartinMartin D'Souzahttps://www.blogger.com/profile/06992954599899886499noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-6510446744524022202014-04-11T14:23:48.775-06:002014-04-11T14:23:48.775-06:00Good Stuff but I do not understand how the same sa...Good Stuff but I do not understand how the same salary can be in two different buckets.Anonymoushttps://www.blogger.com/profile/01325873444964000691noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-48142585809535404942012-06-12T03:00:50.455-06:002012-06-12T03:00:50.455-06:00Realy interesting analytic functions for me, too....Realy interesting analytic functions for me, too. I using and very like ROW_NUMBER(). NTH_VALUE() function new in (oracle database 11g). <br /><br />Thanks for this interesting post.<br /><br />Regards<br />Mahir M. QuluzadeMahir M. Quluzadehttps://www.blogger.com/profile/18093992492396019441noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-69486809071969880932012-06-01T03:16:21.236-06:002012-06-01T03:16:21.236-06:00Great post. I tested and deployed listagg() in an...Great post. I tested and deployed listagg() in an interactive report within ten minutes of reading your article. <br />It was exactly what I'd been looking for.<br /><br />Many thanks. See you at KScope12!Niall Mc Phillips - Long Acrehttps://www.blogger.com/profile/16820246618232119302noreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-64328195795750803522012-05-25T10:09:13.828-06:002012-05-25T10:09:13.828-06:00Brilliant and useful; thanks so much.Brilliant and useful; thanks so much.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2132893136140848212.post-32327468265521615332012-05-23T06:43:01.600-06:002012-05-23T06:43:01.600-06:00Really cool post Martin! Discovered new things tod...Really cool post Martin! Discovered new things today :) I've used in the past before discovering LISTAGG the undocumented wm_concat() which basically groups&concatenates comma separated rows but LISTAGG is the way to go here!Alex Petahttp://www.alexpeta.ronoreply@blogger.com