tag:blogger.com,1999:blog-7395977411859619892.post7352041652853464531..comments2024-01-30T09:21:06.579+01:00Comments on About Oracle: CalendarRob van Wijkhttp://www.blogger.com/profile/00499478359372903250noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-7395977411859619892.post-42828275892436400562008-04-17T21:50:00.000+02:002008-04-17T21:50:00.000+02:00Essentially it is the same query. But I like "my" ...Essentially it is the same query. But I like "my" query a little more because:<BR/><BR/>- the generating of rows is shorter and clearer<BR/><BR/>- the "semana" subquery is not necessary<BR/><BR/>- the column names are confusing and not all columns are actually used<BR/><BR/>But you score points for being first ;-)Rob van Wijkhttps://www.blogger.com/profile/00499478359372903250noreply@blogger.comtag:blogger.com,1999:blog-7395977411859619892.post-18433585381542743182008-04-17T17:33:00.000+02:002008-04-17T17:33:00.000+02:00Wat vind je van deze?http://welman.punt.nl/index.p...Wat vind je van deze?<BR/>http://welman.punt.nl/index.php?r=1&id=420365&tbl_archief=0#420365<BR/>It´s not to difficult to chanche it and get a whole year. Change SPANISH to your language to see the results in yours.Unknownhttps://www.blogger.com/profile/07993943928554400384noreply@blogger.comtag:blogger.com,1999:blog-7395977411859619892.post-63052079892852907062008-02-29T16:16:00.000+01:002008-02-29T16:16:00.000+01:00Rob,That is fantastic. I had seen sample code to g...Rob,<BR/><BR/>That is fantastic. I had seen sample code to generate calendar using MODEL clause, but did not think of this approach. This works in 8i, as well.Narendrahttps://www.blogger.com/profile/14645699853364658640noreply@blogger.com