tag:blogger.com,1999:blog-8677649049588007585.post2419616498029797519..comments2015-03-03T21:12:29.499+00:00Comments on PL/SQL Challenge: Players point out workable solution for 6 July 2010 quiz(462)Steven Feuersteinhttp://www.blogger.com/profile/16619706770920320550noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-8677649049588007585.post-31893025456145234932010-07-07T20:22:06.789+01:002010-07-07T20:22:06.789+01:00Wim, neither unquoted nor quoted identifiers are p...Wim, neither unquoted nor quoted identifiers are permitted to contain a double-quote; therefore, an expression such as SUM(&quot;SharePrice&quot;)would require an alias in order to be referenced as a component of a ROWTYPE variable.<br /><br />Michal&#39;s comment, &quot;I&#39;ll never ever need this information ... [because it] is a bad practice I do not follow&quot; ignores the sometimes unfortunate reality that some (perhaps much) of the code that developers work with was written by others who may not have followed good programming practices.jhall62http://www.blogger.com/profile/10339038131928463003noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-39340394481953673602010-07-07T16:54:38.980+01:002010-07-07T16:54:38.980+01:00Frankly speaking I dnt knw this kind of usage and ...Frankly speaking I dnt knw this kind of usage and I really thank to all those who pointed this out :-) As mark said there should be one option to point an usage like this so that we should have tried that out and learned that then itself.<br /><br />Hope everyone comes here and sees this blog and get this nice little tip.Jaydeephttp://www.blogger.com/profile/17533836153440189719noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-31035106177645284572010-07-07T15:23:16.048+01:002010-07-07T15:23:16.048+01:00Mine opinion is to ask questions like this, no pro...Mine opinion is to ask questions like this, no problem. Even adding this nice &quot;SUM(..&quot; answer is acceptable. But in the answer on this correct choice, a warning should be placed that this type of usage is very tricky, because it could be depending on Oracle versions (it works for 10.2 I noticed), because there are no hard rules in documentation how expressions are referenced. An Oracle update could break this code. What would happen if the field was named &quot;SharePrice&quot; in Oracle. Then it becomes &quot;SUM(&quot;&quot;SharePrice&quot;&quot;)&quot;? I did not test this, leave it as an excercise for the reader.....Wim de Langehttp://www.blogger.com/profile/05505341375827859005noreply@blogger.com