tag:blogger.com,1999:blog-5935044209808828954.post6196726757104728435..comments2023-11-05T02:54:56.307-08:00Comments on The Helsinki Declaration (IT-version): Continuing with part 2 of the Helsinki presentationToon Koppelaarshttp://www.blogger.com/profile/08153913435188725112noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-5935044209808828954.post-51609842519065915842014-10-31T13:55:19.110-07:002014-10-31T13:55:19.110-07:00I know, I know...
Working with Jonathan Gennick on...I know, I know...<br />Working with Jonathan Gennick on maybe doing so. ;-)Toon Koppelaarshttps://www.blogger.com/profile/08153913435188725112noreply@blogger.comtag:blogger.com,1999:blog-5935044209808828954.post-50313150586017005262014-10-31T12:25:38.977-07:002014-10-31T12:25:38.977-07:00This stuff would be great for a book !
- Kyle
This stuff would be great for a book !<br /> - Kyle<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5935044209808828954.post-81790106437112728632009-09-30T00:07:20.872-07:002009-09-30T00:07:20.872-07:00Mr. Toons, You sucked me in and then disappeared??...Mr. Toons, You sucked me in and then disappeared??Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5935044209808828954.post-53531503524872584152009-09-23T21:54:24.602-07:002009-09-23T21:54:24.602-07:00Logic, logic, ...
Any inactivity in this series o...Logic, logic, ...<br /><br />Any inactivity in this series only prooves the point that I currently have too little time to work on new posts.<br /><br />Google analytics shows the series is alive and kicking.Toon Koppelaarshttps://www.blogger.com/profile/08214478545420378529noreply@blogger.comtag:blogger.com,1999:blog-5935044209808828954.post-66695553211939728082009-09-23T18:26:53.120-07:002009-09-23T18:26:53.120-07:00PL/SQL and most stored-procedure languages is too ...PL/SQL and most stored-procedure languages is too deficient to be used to describe any real world business logic.<br /><br />The death of this "declaration" series will proove that point.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5935044209808828954.post-18509624555037987032009-06-17T03:41:37.088-07:002009-06-17T03:41:37.088-07:00Sure - arbitrary user input concatenated into the ...Sure - arbitrary user input concatenated into the SQL:<br />==> unshareable SQL<br />==> SQL injection<br /><br />Cheers,<br />FladoFladohttps://www.blogger.com/profile/04901763101139511192noreply@blogger.comtag:blogger.com,1999:blog-5935044209808828954.post-8326673110370352442009-06-17T02:06:21.150-07:002009-06-17T02:06:21.150-07:00Marcus,
Thanks for the pointer to Oracle magazine...Marcus,<br /><br />Thanks for the pointer to Oracle magazine: I had not yet read that.<br /><br />I use the code for purposes of demonstrating the Helsinki approach, which is: pushing query composition into the DBMS. Not for: what's the superbest way to code this. And so, I was expecting comments about the code: but there is something else in there that's really bad coding practice.<br />Toon Koppelaarshttps://www.blogger.com/profile/08214478545420378529noreply@blogger.comtag:blogger.com,1999:blog-5935044209808828954.post-18653725538930489302009-06-17T00:41:27.626-07:002009-06-17T00:41:27.626-07:00Hello Toon,
one cursor for every possible combina...Hello Toon,<br /><br />one cursor for every possible combination of filters will make the code hard to maintain if you have more than 3 of them.<br /><br />Tom Kyte presents a solution at the current Oracle Magazin: http://www.oracle.com/technology/oramag/oracle/09-jul/o49asktom.html. <br />It allows the optimizer to remove predicates for unused filters.<br /><br />Regards<br />MarcusMarcushttp://matzberger.de/oraclenoreply@blogger.com