tag:blogger.com,1999:blog-8677649049588007585.post9040390022629323195..comments2023-06-18T16:15:22.432+01:00Comments on PL/SQL Challenge: Time to change the default DB version to 11.2?Steven Feuersteinhttp://www.blogger.com/profile/16619706770920320550noreply@blogger.comBlogger15125tag:blogger.com,1999:blog-8677649049588007585.post-79798768162352989892010-11-23T11:45:13.323+00:002010-11-23T11:45:13.323+00:00Great idea, KBH...in fact, I was already planning ...Great idea, KBH...in fact, I was already planning to do this for 1.8 - thought I hadn't thought of version-specific assumptions. I will add that.<br /><br />Thanks, SFSteven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-45062738753291863042010-11-23T08:02:08.910+00:002010-11-23T08:02:08.910+00:00For my score it would be better if we stay with 10...For my score it would be better if we stay with 10g ;-).<br />Until now I have no developer access to an 11g instance. So, switching to 11g would mean for me that I have no chance to do a 'hands on check' on my solution - which I do very often for the (from my experience) more 'exotic' challenges. <br />At the moment most people are able use at least Oracle XE to reproduce the solution or prove their answers.<br />My proposal is to wait until the 11g version of XE is released.<br /><br />Greetings from Germany<br />RalfRalfnoreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-7846356705892721362010-11-23T07:31:06.977+00:002010-11-23T07:31:06.977+00:00I like the idea of periodically polling for which ...I like the idea of periodically polling for which version people use and gradually increasing the number of version 11 questions accordingly.<br /><br />Suggestion:<br /><br />create table dbversions (<br /> version_id varchar2(20),<br /> version_name varchar2(100),<br /> version_assumptions clob<br />);<br /><br />Add column version_id to the question table (I think you may already have it :-)<br /><br />The assumptions page could then show quiz specific version_name and version_assumptions.<br /><br />Then skip the phrase "version 10 unless noted otherwise in the quiz" and train people to always read the version number, name and version specific assumptions for each quiz.<br /><br />Doing that would start getting people used to checking the version information whenever they take a quiz, and then they (maybe :-) won't get confused when more and more v.11 questions start to show up.<br /><br />Just an idea :-)Kim Berg Hansenhttps://www.blogger.com/profile/06491635470794828550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-69028699082499436292010-11-23T04:40:30.561+00:002010-11-23T04:40:30.561+00:00Since "most" pl/sql is the same between ...Since "most" pl/sql is the same between 10g and 11g, it won't make a difference for "most" questions. For the few where there is a difference or new features, is there really any downside to helping people to keep current on their skills?Seanhttps://www.blogger.com/profile/15790298349995376048noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-69170937777199381622010-11-21T21:52:59.861+00:002010-11-21T21:52:59.861+00:00Pretty much what Jeff said, although I think havin...Pretty much what Jeff said, although I think having more 11g questions now will be good for people (including myself) to learn.<br />There are many questions on topics that have been around for years that people are learning for the first time, for whatever reason. Why not 11g topics?Scott Wesleyhttps://www.blogger.com/profile/18106937181788036683noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-71840683534580439062010-11-20T11:46:23.104+00:002010-11-20T11:46:23.104+00:00For most people the plsql challenge is also a lear...For most people the plsql challenge is also a learning experience. I think that it is better to switch to release 11g. For the players who work with older version can also learn about the new features and we still can have question about the older features.Marc Bouwenshttp://www.hankenaar.nlnoreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-62008309753362506372010-11-20T08:48:03.351+00:002010-11-20T08:48:03.351+00:00A player without access to Blogger asked me to pos...A player without access to Blogger asked me to post this:<br /><br />I think that a change to the database version is not so good at this time, because it could be, that some of the players only have experience with the XE version and thats still an Oracle Database Release 10.2.<br /> <br />I personally already use 11g R1 and 11g R2, but we only have Standard Editions here, so even on questions about the function result cache I must look at the documentation, because I haven't any experience with it. So if you make a poll about the database versions you should also think about including the edition into the question.Steven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-86921257041932688772010-11-20T07:40:31.036+00:002010-11-20T07:40:31.036+00:00For your statistics, most of my current work done ...For your statistics, most of my current work done on Oracle10g. But I'm studying a new features of 11gR2 when I am not too busy. <br /><br />For the time to switch default version, I don't think it make any troubles. I think most questions still have the same answers but if you want to test, you have to do on 11g instance.<br /><br />However, if you decide to switch, could you skip 11gR1 and use 11gR2 instead. It may not a good reason but I think I have no chance to play on 11gR1 ones.siamnobitahttps://www.blogger.com/profile/02925596241710939090noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-81926446284397787452010-11-19T20:01:57.655+00:002010-11-19T20:01:57.655+00:00I'd be happy with 11g questions. Makes it more...I'd be happy with 11g questions. Makes it more of a 'learning' challenge.<br />For people who don't have an 11g database (OTN licence or work) you can get a free workspace at apex.oracle.com, which is 11gR2<br />At an OpenWorld interview Mark Townsend said that they were working on 11gR2 XESydOraclehttps://www.blogger.com/profile/08828771074492585943noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-12849834718916754442010-11-19T12:19:49.064+00:002010-11-19T12:19:49.064+00:00I think that because this is a challenge, it shoul...I think that because this is a challenge, it should be up to date.<br /><br />My 'job' blocks me with old(even though valid)Oracle versions. I must do it!<br />My preferred community shouldn't block me in the same way!<br /><br />GiuseppeAnonymoushttps://www.blogger.com/profile/05472680452207585354noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-87463049450389094882010-11-19T09:40:42.477+00:002010-11-19T09:40:42.477+00:00I also encounter lots of database versions -- inde...I also encounter lots of database versions -- indeed ranging from 8i to 11gR2. I guess that for must of us it would be puzzling to answer a question on which version you're using. <br />My point was to draw a line somewhere. Following the official "Lifetime support" documentation provides for a globally communicated end-of-support date.<br />Skipping through the growing database of previously submitted PL/SQL Challenge questions, I don't think the shift to the basic assumption of 11gR1 would make really much of a difference -- so why not...Rob van den Berghttps://www.blogger.com/profile/03797947431578815225noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-5961223896339349482010-11-19T07:56:04.827+00:002010-11-19T07:56:04.827+00:00I think a shift now is very reasonable. 11g Releas...I think a shift now is very reasonable. 11g Release 1 has been out for more than three years. Version 11g Release 2 for more than a year. In my opinion it definitely is the "version they should be aware of and learning about".<br /><br />Regards,<br />Rob.Rob van Wijkhttps://www.blogger.com/profile/00499478359372903250noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-10639601788308152772010-11-19T07:30:18.148+00:002010-11-19T07:30:18.148+00:00I enjoy the 11g questions from time to time, and h...I enjoy the 11g questions from time to time, and hope to see more.<br /><br />I'd prefer that you wait a bit longer before switching *entirely* over to 11g. I'm still working on a migration of data from an 8i instance, I still get work on 9i databases quite often, and most of my work is still on 10g.<br /><br />I'd like to see a poll, updated every 3 months, asking which database version each player is working on primarily; once the poll indicates that a majority (or perhaps >60%) of people are working on 11g, I'd say move the quiz then.<br /><br />Until then, however, knowledge of older versions is still valuable - and as organisations upgrade, it is important to know how things differ between 10g and 11g.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-25131974737964632272010-11-19T07:30:08.820+00:002010-11-19T07:30:08.820+00:00Make it a quiz - interesting idea. But I don't...Make it a quiz - interesting idea. But I don't think I can do that as a substitute for the daily quiz. I will, instead and as soon as possible, add polls to the website (which are, as you imply here, a kind of quiz) to make it easier to gather information.<br /><br />But I think the question here is that at some point in time, it is not so much which version people are using, but which version they should be aware of and learning about.<br /><br />SFSteven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-57229856281363980162010-11-19T07:17:27.062+00:002010-11-19T07:17:27.062+00:00It could be that 11 is now the version sold, but m...It could be that 11 is now the version sold, but my guess is that most of the people are still using 10.2. Legacy systems don't change so fast in Oracle versions. I bet that lots of companies are still running 8.<br /><br />Suggestion. Make it a quiz? Which production version are you running? Everyone get's a 100% score on this and you know the statistics.Wim de Langehttps://www.blogger.com/profile/05505341375827859005noreply@blogger.com