tag:blogger.com,1999:blog-1271763227002553835.post5433131121437788126..comments2024-03-26T08:42:34.744+01:00Comments on Notes on Oracle: Analytic Function: Finding GapsAlex Nuijtenhttp://www.blogger.com/profile/06345615264010120428noreply@blogger.comBlogger23125tag:blogger.com,1999:blog-1271763227002553835.post-77980913694388807762016-07-20T11:36:17.663+02:002016-07-20T11:36:17.663+02:00Hi Tom, I have a simple SQL question on how to fin...Hi Tom, I have a simple SQL question on how to find gaps. Immagine a ... Would you also know of a way to do this without analytic functions? <a href="https://www.gangboard.com/business-intelligence-training/r-programming-training" rel="nofollow">R Programming Training</a> | <a href="https://www.gangboard.com/etl-training/datastage-training" rel="nofollow">DataStage Training</a> | <a href="https://www.gangboard.com/database-training/sql-training" rel="nofollow">SQL Training</a> | <a href="https://www.gangboard.com/business-intelligence-training/sas-training" rel="nofollow">SAS Training</a> | <a href="https://www.gangboard.com/app-programming-scripting-training/android-training" rel="nofollow">Android Training</a> | <a href="https://www.gangboard.com/microsoft-training/sharepoint-training" rel="nofollow">SharePoint Training</a>Anonymoushttps://www.blogger.com/profile/16683630197266042568noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-7655473637655002762016-06-16T06:56:33.676+02:002016-06-16T06:56:33.676+02:00thanku for sharig..
Informatica training, in the r...thanku for sharig..<br />Informatica training, in the recent times has acquired a wide scope of popularity amongst the youngsters at the forefront of their career. <br /><a href="http://hadooptraininginhyderabad.co.in/informatica-training-in-hyderabad/" rel="nofollow">Informatica online training in hyderabad</a><br /><br /><br />Anonymoushttps://www.blogger.com/profile/17301444187994383250noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-49524233835246778102016-01-29T01:47:58.636+01:002016-01-29T01:47:58.636+01:00Very helpful. Followed your design above for a rep...Very helpful. Followed your design above for a report I am building at work. Worked out very well plus I just learned something new today!Hosea216https://www.blogger.com/profile/13703692904841820718noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-43350393488118200492015-11-27T09:02:41.877+01:002015-11-27T09:02:41.877+01:00Nice Blog , This is what I exactly Looking for , K...Nice Blog , This is what I exactly Looking for , Keep sharing more blog .<br /><br /><a href="http://www.amitysoft.com/data_analytics_&_visualization.html" rel="nofollow">Bigdata Analytics</a>shankarhttps://www.blogger.com/profile/08554007586508455118noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-27794395836931830972015-11-24T20:42:46.199+01:002015-11-24T20:42:46.199+01:00You saved my day, thanks for sharing you experienc...You saved my day, thanks for sharing you experience Anonymoushttps://www.blogger.com/profile/00224638307738558763noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-81240203630610352492015-08-28T11:59:46.557+02:002015-08-28T11:59:46.557+02:00Oracle Database Training will help you develop a t...Oracle Database Training will help you develop a thorough understanding of Oracle Database, as well as its related products. With more than 50 Database offerings, enhance your knowledge of Database 11g, MySQL, Data Guard, and more.<br /><br /><a href="http://www.oracletraining.co.in/plsql-training-in-chennai/" rel="nofollow">SQL Training in Chennai</a><br /><a href="http://www.fitaacademy.com/courses/oracle-training-in-chennai/" rel="nofollow">Oracle Training in Chennai</a><br />Arjun kumarhttps://www.blogger.com/profile/16771393278917216926noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-3862761839008157142015-08-12T13:40:48.339+02:002015-08-12T13:40:48.339+02:00This comment has been removed by a blog administrator.Anonymoushttps://www.blogger.com/profile/06913564432149898500noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-16227259907271318812015-08-12T08:02:49.611+02:002015-08-12T08:02:49.611+02:00This comment has been removed by a blog administrator.Anonymoushttps://www.blogger.com/profile/11926072654511430884noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-30079803747791833932015-08-11T09:02:57.565+02:002015-08-11T09:02:57.565+02:00This comment has been removed by a blog administrator.Rahulhttps://www.blogger.com/profile/11428449970397557798noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-36528971575807336262015-05-09T11:35:01.887+02:002015-05-09T11:35:01.887+02:00I gathered a lot of information through this artic...I gathered a lot of information through this article.Every example is easy to understandable and explaining the logic easily.Thanks! <a href="http://suranka.com/training-courses/cloud-computing-training/amazon-web-services-training-in-chennai" rel="nofollow">AWS Training in chennai</a> | <a href="http://suranka.com/training-courses/cloud-computing-training/amazon-web-services-training-in-chennai" rel="nofollow">AWS Training chennai</a> | <a href="http://suranka.com/training-courses/cloud-computing-training/amazon-web-services-training-in-chennai" rel="nofollow">AWS course in chennai</a><br /><br />Anonymoushttps://www.blogger.com/profile/09165633482704057888noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-90107749336446890472015-05-09T11:33:15.543+02:002015-05-09T11:33:15.543+02:00Your posts is really helpful for me.Thanks for you...Your posts is really helpful for me.Thanks for your wonderful post. I am very happy to read your post. <a href="http://suranka.com/training-courses/cloud-computing-training/" rel="nofollow">cloud computing training in chennai</a> | <a href="http://suranka.com/training-courses/cloud-computing-training/" rel="nofollow">cloud computing training chennai</a> | <a href="http://suranka.com/training-courses/cloud-computing-training/" rel="nofollow">cloud computing course in chennai</a> | <a href="http://suranka.com/training-courses/cloud-computing-training/" rel="nofollow">cloud computing course chennai</a> <br />surangacloudhttps://www.blogger.com/profile/13630643168042875664noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-4012831994766461712015-04-15T12:31:37.753+02:002015-04-15T12:31:37.753+02:00Nice article i was really impressed by seeing this...Nice article i was really impressed by seeing this article, it was very interesting and it is very useful for Learners.. <br /><a href="http://suranka.com/training-courses/web-designing-training/" rel="nofollow">Web designing Training in chennai</a> | <a href="http://suranka.com/training-courses/web-designing-training/" rel="nofollow">Web designing Training chennai</a> <a href="http://suranka.com/training-courses/web-designing-training/" rel="nofollow">Web designing course in chennai</a> | <a href="http://suranka.com/training-courses/web-designing-training/" rel="nofollow">Web designing course chennai</a> |<br />Anonymoushttps://www.blogger.com/profile/02579408741780286346noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-639228691413899332015-04-13T13:37:01.745+02:002015-04-13T13:37:01.745+02:00Oracle Training
The information you posted here i...<a href="http://www.fita.in/oracle-training-in-chennai/" rel="nofollow">Oracle Training</a><br /><br />The information you posted here is useful to make my career better keep updates..If anyone want to become an oracle certified professional reach FITA <a href="http://www.fita.in/oracle-training-in-chennai/" rel="nofollow">Oracle Training Center in Chennai</a>, which offers Best <a href="http://www.fita.in/oracle-training-in-chennai/" rel="nofollow">Oracle Training in Chennai</a> with years of experienced professionals. <br />Anonymoushttps://www.blogger.com/profile/01882839630037611834noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-69277915516619315022015-03-14T13:46:23.610+01:002015-03-14T13:46:23.610+01:00Your blog is really useful for me. Thanks for shar...Your blog is really useful for me. Thanks for sharing this informative blog. If anyone wants to get real time <a href="http://www.oracletraining.co.in/" rel="nofollow">Oracle Training Chennai</a> reach FITA <a href="http://www.fita.in/oracle-training-in-chennai/" rel="nofollow">Oracle Training Institutes in Chennai</a>. They give professional and job oriented training for all students.<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-90331621397416901712015-02-11T11:05:46.484+01:002015-02-11T11:05:46.484+01:00really helpful
Oracle Training in Chennaireally helpful<br /><a href="http://www.besanttechnologies.com/training-courses/oracle-training" rel="nofollow">Oracle Training in Chennai</a>Anonymoushttps://www.blogger.com/profile/01915010731519737915noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-4612309086467088212015-02-11T11:05:15.438+01:002015-02-11T11:05:15.438+01:00thank you so muchthank you so muchAnonymoushttps://www.blogger.com/profile/01915010731519737915noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-42676153537989486232014-04-25T19:45:38.523+02:002014-04-25T19:45:38.523+02:00Interesting! Thank you for writing all of the code...Interesting! Thank you for writing all of the code in detail.<br /><br />- Susan<br /><a href="http://www.princepizzeria.com/party-venue-danvers-ma/" rel="nofollow">Danvers Function Rooms</a>Anonymoushttps://www.blogger.com/profile/09424178758586739931noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-84451161422407248672013-10-11T19:27:47.156+02:002013-10-11T19:27:47.156+02:00Thank you! This was so helpful. The step by step...Thank you! This was so helpful. The step by step approach you took made trying to replicate this with my variables very understandable.<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-45569775950613505572012-01-24T05:58:02.567+01:002012-01-24T05:58:02.567+01:00Beautiful - I was just about to write some ugly cu...Beautiful - I was just about to write some ugly cursor code when I found this.Simon McKenziehttps://www.blogger.com/profile/17914370041243730692noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-22805455440530697382010-02-11T06:56:05.567+01:002010-02-11T06:56:05.567+01:00Salman
I like this query i was stuck in a problem ...Salman<br />I like this query i was stuck in a problem but this query help me a lot. thank thanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-7134118372541548262009-08-28T16:52:49.688+02:002009-08-28T16:52:49.688+02:00I really like the step by step approach to the fin...I really like the step by step approach to the final solution. I really like analytic functions now after reading this post. Thanks!!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-55878495649257516422009-08-05T02:58:46.183+02:002009-08-05T02:58:46.183+02:00Well Done. If the application uses a null end_date...Well Done. If the application uses a null end_date to indicate an open-ended span, the Max(end_date) returns the highest non-null date in the span group. That turned out to be an error in my application, but not hard to correct by nvl(end_date,'31-DEC-4444') in the innermost view.<br /><br />Good explaination too. ThanksJim Kolberghttps://www.blogger.com/profile/08798446213089699476noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-80146505651779509822009-06-16T22:55:55.247+02:002009-06-16T22:55:55.247+02:00Alex,
I never expected such a fantastic response ...Alex,<br /><br />I never expected such a fantastic response to this query. Your solution is far superior to mine--just what I was looking for.<br /><br />Thanks,<br /><br />AntonAnton Nielsenhttps://www.blogger.com/profile/01507583135719899159noreply@blogger.com