tag:blogger.com,1999:blog-20160325.post3779064495515861181..comments2022-12-11T06:49:09.876-08:00Comments on FeuerThoughts: PL/SQL Challenge not useful if you're not on Oracle11g?Steven Feuersteinhttp://www.blogger.com/profile/16619706770920320550noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-20160325.post-61449516610534436592010-06-11T08:20:17.803-07:002010-06-11T08:20:17.803-07:00It's easy to prepare for the 11g result cache ...It's easy to prepare for the 11g result cache feature!<br /><br />Stop writing queries in your application code. Instead, put EVERY SINGLE QUERY inside its own function, and call the function.<br /><br />Then when you upgrade, you add RESULT_CACHE to the function and you are done.<br /><br />Does that answer the question?<br /><br />SFSteven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-20160325.post-44336398414485825582010-06-08T04:37:10.931-07:002010-06-08T04:37:10.931-07:00Hi Steven,
I have a question that is annoying me,...Hi Steven,<br /><br />I have a question that is annoying me, and frankly, quite a lot.<br />[about Result Cache]: "it is so powerful and important that once you learn about it, it should change the way you write your applications right now".<br />And the "great" question is:<br /><br />How do I accomplish this? That is, how do I write 11g ready code on a 10gR2.<br /><br />Some days ago I went through some refactoring on a package, and I wanted to set up result cache for some functions (user and general application parameters) through conditional compilation but with no luck :(.<br /><br />I currently use 10gR2, and I will have to wait quite a bit for 11g.<br /><br />Thanks a lot,<br />João BarretoJoão Borges Barretohttps://www.blogger.com/profile/09625758342698621527noreply@blogger.com