tag:blogger.com,1999:blog-8677649049588007585.post5061292075235676839..comments2023-06-18T16:15:22.432+01:00Comments on PL/SQL Challenge: Missing RETURN in 28 September quiz - but no impact on correctness! (1442)Steven Feuersteinhttp://www.blogger.com/profile/16619706770920320550noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-8677649049588007585.post-42516006463506491002010-09-30T12:34:58.697+01:002010-09-30T12:34:58.697+01:00Siamnobita,
Yes, I see your point. The answer &q...Siamnobita, <br /><br />Yes, I see your point. The answer "works" but only because of the assumptions, which means that there are no other objects. I will adjust that question text to address this.<br /><br />SFSteven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-717265284353876002010-09-30T07:08:56.297+01:002010-09-30T07:08:56.297+01:00This is a reaction on the blog. Like the new forma...This is a reaction on the blog. Like the new format. It is less compact then the previous one, on a big screen (1366 x 768 gives a lot of whitespace), but it is much nicer and look more like the pl/sql challange as it should be.Wim de Langehttps://www.blogger.com/profile/05505341375827859005noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-82381483015253930032010-09-30T06:27:14.286+01:002010-09-30T06:27:14.286+01:00Filipe Silva, I have read the assumption and have ...Filipe Silva, I have read the assumption and have no question on the scoring of that choice but I have question only on the word describe why the choice is correct. <br /><br />"This query retrieves dependency information from the user_dependencies view, so it does not need to include a WHERE clause predicated for the owner of the object."<br /><br />My point is column 'REFERENCED_OWNER' should not be eliminated just because you select from user's views. And IMHO, his word can imply that this column is not necessary if you select from this view.siamnobitahttps://www.blogger.com/profile/02925596241710939090noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-87271172246377063552010-09-29T20:03:17.666+01:002010-09-29T20:03:17.666+01:00The thing in USER in the WHERE statement... Should...The thing in USER in the WHERE statement... Shouldn't we use USER_DEPENDENCIES instead of ALL_DEPENDENCIES+WHERE?Unknownhttps://www.blogger.com/profile/16279008641149475715noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-74258794496904758602010-09-29T14:09:38.285+01:002010-09-29T14:09:38.285+01:00siamnobita, please read (and understand) the assum...siamnobita, please read (and understand) the assumptions.<br /><br />The assumption for the quiz is that the only DB objects that exist are those described in the quiz itself (or defined by Oracle with the installation of the database).Filipe Silvahttps://www.blogger.com/profile/07846537897685950997noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-19761031072577625042010-09-29T11:34:46.366+01:002010-09-29T11:34:46.366+01:00In my opinion the missing predicate in the WHERE-c...In my opinion the missing predicate in the WHERE-clause for the referenced_owner isn't neccessary, because in a default installation of Oracle there is on table named "PLCH_PARTS".Niels Heckerhttps://www.blogger.com/profile/01416262288792133003noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-75996443790703394592010-09-29T10:22:11.524+01:002010-09-29T10:22:11.524+01:00That's actually what shifted my mind :(. I hav...That's actually what shifted my mind :(. I haven't chosen a single answer because I thought it would not compile and only after I pressed 'Submit' button, I realized that it would be runtime error 'The function returned without value' but not a compilation error.<br />Thigh...Shmyghttps://www.blogger.com/profile/02764117015759339441noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-37422129404249455272010-09-29T04:14:33.606+01:002010-09-29T04:14:33.606+01:00I have a question on your answers of choice "...I have a question on your answers of choice "SELECT COUNT (*) FROM user_dependencies WHERE referenced_name = 'PLCH_PARTS' AND referenced_type = 'TABLE'" and you said "This query retrieves dependency information from the user_dependencies view, so it does not need to include a WHERE clause predicated for the owner of the object. This query will display "2"." I think that althrough you are selecting from user_dependencies view, the WHERE on referenced_owner is still needed if you referenced objects in other schema. This choice is correct just because you have only one reference to 'PLCH_PARTS' in one schema.siamnobitahttps://www.blogger.com/profile/02925596241710939090noreply@blogger.com