tag:blogger.com,1999:blog-8677649049588007585.post3101226113517071247..comments2023-06-18T16:15:22.432+01:00Comments on PL/SQL Challenge: Problems with 27 August quiz - undocumented features, ambiguous wording (1365)Steven Feuersteinhttp://www.blogger.com/profile/16619706770920320550noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-8677649049588007585.post-57663174949221325152010-08-30T12:34:48.699+01:002010-08-30T12:34:48.699+01:00Ah...and one other thing: the ALL_PROCEDURES selec...Ah...and one other thing: the ALL_PROCEDURES select I show in my original post should have an "OWNER =" clause in it, as should any query against an "ALL*" view. Otherwise you might get "hits" for objects in other schemas.<br /><br />This is not an issue in the quizzes, since one of the assumptions states that the only DB objects present are those defined in the quiz itself, but that is NOT an assumption you can rely on in the real world.Steven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-67411920148857958082010-08-30T12:32:18.677+01:002010-08-30T12:32:18.677+01:00Thanks, al0. It sure would be nice if Oracle would...Thanks, al0. It sure would be nice if Oracle would document new features added incrementally, so there was a clear record of what was added when.<br /><br />I will update my quiz to make sure it is accurate. <br /><br />What do you think is ambiguous about "The value of the object_name column is not NULL and that of the procedure_name column is NULL if the program unit is a schema-level procedure or function"?<br /><br />SFSteven Feuersteinhttps://www.blogger.com/profile/16619706770920320550noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-13650899789551804942010-08-30T08:46:27.505+01:002010-08-30T08:46:27.505+01:00Hi,
as may be seen from the SQL*Plus output below...Hi,<br /><br />as may be seen from the SQL*Plus output below OVERLOAD column exists in 10.2 (at least 10.2.0.4):<br />================================================<br />SQL*Plus: Release 10.2.0.3.0 - Production on Mon Aug 30 09:29:33 2010<br /><br />Copyright (c) 1982, 2006, Oracle. All Rights Reserved.<br /><br /><br />Connected to:<br />Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production<br />With the Partitioning, OLAP, Data Mining and Real Application Testing options<br /><br />Name Null? Type<br />----------------- -------- ---------------------<br />OWNER VARCHAR2(30)<br />OBJECT_NAME VARCHAR2(30)<br />PROCEDURE_NAME VARCHAR2(30)<br />OBJECT_ID NUMBER<br />SUBPROGRAM_ID NUMBER<br />OVERLOAD VARCHAR2(40)<br />OBJECT_TYPE VARCHAR2(19)<br />AGGREGATE VARCHAR2(3)<br />PIPELINED VARCHAR2(3)<br />IMPLTYPEOWNER VARCHAR2(30)<br />IMPLTYPENAME VARCHAR2(30)<br />PARALLEL VARCHAR2(3)<br />INTERFACE VARCHAR2(3)<br />DETERMINISTIC VARCHAR2(3)<br />AUTHID VARCHAR2(12)<br />SQL> <br />================================================<br />So it was not not "only added in Oracle11g".<br /><br />Then regarding wording - "This view allows you to determine whether a schema-level program unit is a function or procedure." does not imply that the program unit may be ONLY a function or procedure. <br />Otherwise one more wording should be treated as ambiguous, namely "The value of the object_name column is not NULL and that of the procedure_name column is NULL if the program unit is a schema-level procedure or function".al0https://www.blogger.com/profile/15743792964167204705noreply@blogger.com