tag:blogger.com,1999:blog-8677649049588007585.post247112135461647485..comments2023-06-18T16:15:22.432+01:00Comments on PL/SQL Challenge: When is a table JUST a table? The danger of making assumptions(324)Steven Feuersteinhttp://www.blogger.com/profile/16619706770920320550noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-8677649049588007585.post-35863249803842314122010-06-02T03:16:16.997+01:002010-06-02T03:16:16.997+01:00The quiz questions are often tricky and there are ...The quiz questions are often tricky and there are many possibilities in answers, like all the options may be correct or none of them.<br /><br />Considering this situation, it happens sometimes that if you don't correctly interpret the question, you may select wrong choices even if you know the answer and concept behind the question. So it is obvious for any player to take extra precaution and derive different meanings from a question when he/she sees an option matching close to the answer to question. That is what happened here.<br /><br />I am in total agreement that TABLE means a database table (of course) but PL/SQL TABLEs (associative arrays) are treated much similar to real database tables in some cases like "when referenced element does not exists in an associative array, NO_DATA_FOUND exception is raised".Rameshhttps://www.blogger.com/profile/04557315341209397856noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-23970730617956873322010-05-31T09:53:30.458+01:002010-05-31T09:53:30.458+01:00A Table in DB context for me its evidently a datab...A Table in DB context for me its evidently a database table (I also do not think it should be necessary to qualify the word "table" in the context of PL/SQL programming). <br />A Nested Table is a collection, like associative arrays (formerly called PL/SQL table :-))Filipe Silvahttps://www.blogger.com/profile/07846537897685950997noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-29023494886921983102010-05-31T07:23:46.803+01:002010-05-31T07:23:46.803+01:00I agree on the fact that the term "table"...I agree on the fact that the term "table" refers to the object that is sitting in a database without any special properties (like temporary tables). It is like object oriented languages. You have the generic term, and you have specific terms that look like the original object but could be implemented and behave in a complete different manner.<br />I must admit this is a hard discussion. But if you must specify exactly what you mean in a challenge, then they will become unreadable and are not fun anymore todo.Wim de Langehttps://www.blogger.com/profile/05505341375827859005noreply@blogger.com