tag:blogger.com,1999:blog-8677649049588007585.post7684625830510504001..comments2023-06-18T16:15:22.432+01:00Comments on PL/SQL Challenge: Ideas for PL/SQL Challenge 2.3Steven Feuersteinhttp://www.blogger.com/profile/16619706770920320550noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-8677649049588007585.post-16205062791257916532012-05-23T18:47:41.998+01:002012-05-23T18:47:41.998+01:00Hello All,
I try to understand the proposal of th...Hello All,<br /><br />I try to understand the proposal of the previous posters.<br /><br />As far as I understand, each quiz has a well-defined topic<br />from its very creation by the author, and eventually amended<br />by Steven or by the reviewers, let's call this the "main" topic<br />of the quiz.<br /><br />As the language becomes more and more complex, and the PL/SQL Challenge also ( kudos to our entire community :) ),<br />it is very probable that many quizzes, perhaps with the exception of some "very beginner" quizzes, do touch besides<br />their main topic, one or more additional topics, related more<br />or related less to the main topic.<br />As the previous posters already underlined, this categorization<br />can become very subjective.<br /><br />So, something really ideal if it could be implemented would<br />be to allow each player "to attach" to each quiz his own<br />additional "list of topic keywords", chosen from a wide list of (secondary) topics which the player considers relevant to that quiz, maybe from his own very specific point of view.<br /><br />The list of possible keywords could be left to be as wide as<br />the entire PL/SQL Language, that is, without predefining <br />a limited list of topics for each quiz, which would create<br />additional work and challenge to the authors and reviewers.<br /><br />Then, on the Library page, to allow a player to search the <br />quizzes database by such specific "topic keywords" attached by himself to each quiz.<br /><br />Searching by the "main" quiz topic is already available <br />for the Library page, as well as in the framework of new "Practices" feature.<br /><br />The above addition could add the possibility of a <br />"custom categorization" by the player's own definition,<br />probably the maximum flexibility that one might ask for.<br /><br />As you can see, the appetite comes with the food :) :)<br /><br /><br />I agree with Chris regarding the utility of the featured discussions, including here the SQL quizzes also.<br />Along this line, I also was thinking of what could be done<br />to popularize other solutions that players might have found<br />for some tricky quizzes.<br />A good example ? The SQL quiz of of Lucas Jellema<br />from AMIS played on Apr 7 2012.<br /><br />Just some ideas, as "last thoughts before the Playoff day" :)<br /><br />Thanks a lot & Best Regards,<br />Iudith Mentzeliudithhttps://www.blogger.com/profile/04905902445036068357noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-67606532838970280462012-05-23T15:01:23.055+01:002012-05-23T15:01:23.055+01:00The "backbone" of the PL/SQL Challenge i...The "backbone" of the PL/SQL Challenge is a tree of language features (separate trees for SQL, APEX, PL/SQL, etc.). You can see this tree when you set up a practice or quizbook by features. <br /><br />Virtually all the "categories" you list above are "parent" features in the tree. <br /><br />So I think that the Favorites enhancement would handle your needs pretty well. You identify favorite features from the tree, and then ask to filter quizzes to your favorites.Steven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-33131298826616534122012-05-23T13:39:55.299+01:002012-05-23T13:39:55.299+01:00I was about to suggest something potentially simil...I was about to suggest something potentially similar - to allow the user to filter their rankings by features that they actually use on a regular basis.<br />Maybe, on the question itself or its feedback, there could be checkboxes for, eg:<br />- A question I should be familiar with<br />- A question whose theme I'm keen to improve in<br />By all means keep the overall rankings for global comparison - but this will enable people to not stress over a failure on a particular question because it's not a feature they need to/should use for the application(s) on which they work.gulbrainhttps://www.blogger.com/profile/17079790265927022464noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-59572980031363785632012-05-22T20:14:29.044+01:002012-05-22T20:14:29.044+01:00it hard to dissect the language, especially that &...it hard to dissect the language, especially that "dissection" would be very subjective.Few to name:<br />Built-in packages, stand-alone functions, analytically functions, exception handling, program flow, arrays, data types (sql, pl/sql , sql VS. pl/sql) , OOP features of the language, dynamic SQL.<br />Under "enabling this feature" i meant to have a report that breaks all answered questions by the categories ,allows to sort. <br />Another approach that targets similar objective is to have custom tags that would allow one custom categorization. Then "personal dashboard" becomes indicator of weak areas. <br /><br />It easy to compete against someone, it hard to compete against yourself. ;-)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-48328040379599964382012-05-22T15:40:24.572+01:002012-05-22T15:40:24.572+01:00Could you give some examples of the categorization...Could you give some examples of the categorization you have in mind? And what would you enable on the personal page (profile?) in this regard? <br /><br />Thanks! SFSteven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-27609710164586263662012-05-22T15:30:50.480+01:002012-05-22T15:30:50.480+01:00Over the past decade PL/SQL has grown from domain ...Over the past decade PL/SQL has grown from domain specific language to almost full fledged language. And it's not simple to keep up with ALL aspects of language and new features (at least for me). So what I would like to see is the "category of question".<br />And while taxonomy (categorization) is subjective, nonetheless that feature would pinpoint to the area(s) that need improvements.<br />Obviously, that would have to be enabled on the personal page to allow sorting and analyzing.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-21842681636144121322012-05-21T00:58:21.022+01:002012-05-21T00:58:21.022+01:00That's a fascinating idea, Chris.
I have long...That's a fascinating idea, Chris.<br /><br />I have long planed to add a Code section to the PL/SQL Challenge, so that players can upload their library of useful scripts and code, either to simply have a repository in which they can search through their own scripts or to share them with others.<br /><br />The featured discussion could easily lead to some nice contributions in this area.Steven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-5662373289053822532012-05-20T20:09:24.201+01:002012-05-20T20:09:24.201+01:00I like the idea of featured discussions - it could...I like the idea of featured discussions - it could be a good way to bounce ideas off other players.<br /><br />I think it would be interesting if this could be used to help promote, discuss and/or develop standard utility libraries (e.g. logging, error management, etc.) which could be useful for the wider community.Chris Saxonhttps://www.blogger.com/profile/09485645419920814104noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-72130290608243636092012-05-16T21:42:58.653+01:002012-05-16T21:42:58.653+01:00I will look into adding that information to the Li...I will look into adding that information to the Library page. <br /><br />Regarding "Rank Me" - yes, good point in that in terms of ranking there will really not be any difference between not playing and going "unranked" for a period of time. But all the restrictions about only being able to switch back to competitive from non-competitive disappear with Rank Me. You can change your status for a given competition at any time. Rankings will only be calculated from quizzes you took while you were being ranked. <br /><br />I haven't yet thought about showing stats for ranked and unranked quizzes. I will look into that. Thanks!Steven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-11766692821868933922012-05-16T21:28:13.637+01:002012-05-16T21:28:13.637+01:00Do you have any further info on the "Rank Me&...Do you have any further info on the "Rank Me" item, as it is not clear to me how being on vacation is any different from simply not taking the quiz? If an individual is on vacation and selects to not be ranked, comes back from vacation and changes back to being ranked, does that start again with the next quarter, or would they disappear from the rankings when leaving for vacation and then automagically reappear in the current quarter's ranking upon returning from vacation? <br /><br />Perhaps this could/should lead to an individual potentially having a breakdown of their scores, at least on their personal page. You could have your stats for all of the ranked quizzes (visible in rankings), along with your stats for the unranked quizzes (not visible in rankings).Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-17315352408181562472012-05-16T21:23:57.000+01:002012-05-16T21:23:57.000+01:00What I would like to see is a change in the quiz l...What I would like to see is a change in the quiz library. That the two columns "Objection?" and "Last Comment" are merged into one column and make it visible what kind of commentary exists on the quiz (by an icon?), the date and time of the last entry and if it was submitted or rejected (for objections). If there are an "Ask For Help", "Raise Objection" and "Start Discussion" there should also be three entries.<br />Niels HeckerAnonymousnoreply@blogger.com