tag:blogger.com,1999:blog-8677649049588007585.post7242039094137195488..comments2023-06-18T16:15:22.432+01:00Comments on PL/SQL Challenge: The quote character (q) and the 4 November quiz (1604)Steven Feuersteinhttp://www.blogger.com/profile/16619706770920320550noreply@blogger.comBlogger12125tag:blogger.com,1999:blog-8677649049588007585.post-67205859158546465242010-11-08T10:16:16.177+00:002010-11-08T10:16:16.177+00:00This is a first time the quiz addresses the featur...This is a first time the quiz addresses the feature I never have heard of. Thank you, Steven!al0https://www.blogger.com/profile/15743792964167204705noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-65543223867481915732010-11-08T02:48:18.467+00:002010-11-08T02:48:18.467+00:00Like Richard M, I also got a slew wrong because I ...Like Richard M, I also got a slew wrong because I didn't know paired delimiters would work.<br /><br />I'd have much preferred one single option on matched delimiters. But then, due to the gross markdown on my score, I will never, ever forget that matched delimiters are an option.Ken Rowhttps://www.blogger.com/profile/02740427410810311883noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-24356050670541502082010-11-06T01:09:43.606+00:002010-11-06T01:09:43.606+00:00I've seen no problems with this mechanism, but...I've seen no problems with this mechanism, but I am using the 11gR2 client with 11gR1 and 11gR2 databases. Perhaps the Quiz Assumptions should be amended to include a statement that the client is the one included with the target version of the database.jhall62https://www.blogger.com/profile/10339038131928463003noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-65738543037806312792010-11-05T15:23:12.913+00:002010-11-05T15:23:12.913+00:00Wow, I've used this with the pound symbol (#) ...Wow, I've used this with the pound symbol (#) a lot... but I never knew it did the paired delimiters. I got all of those wrong because of that. :(<br /><br />Learned something new and useful!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-78702190209566628232010-11-05T13:49:41.310+00:002010-11-05T13:49:41.310+00:00No problems here, but 10 database and 10 and 11 cl...No problems here, but 10 database and 10 and 11 clients, also Toad 11 beta works.<br /><br />About the comma, there are two issues with it The second one can change the meaning of the sentence, but the first on in 'Hello,' looks like half a sentence. So the speaker is not finished yet with his sentence. This comma should be a period?Wim de Langehttps://www.blogger.com/profile/05505341375827859005noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-83509205004114975042010-11-05T11:25:43.307+00:002010-11-05T11:25:43.307+00:00I believe this issue was reported in Metalink as a...I believe this issue was reported in Metalink as a bug, though I can't find it anymore.<br /><br />When using an older (i.e. 9i) client, then a string with an odd number of single quotes fails with an ora-01756 (quoted string not properly terminated).<br />A string with an even number of single quotes will work as expected!theoahttps://www.blogger.com/profile/16822285145251788576noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-59246729634895048912010-11-05T11:21:36.369+00:002010-11-05T11:21:36.369+00:00Re. the presence of the comma, I'd say it was ...Re. the presence of the comma, I'd say it was fine, if you were referring to "the man" as the object, and not referring to someone with the title of "the man who didn't like goodbyes".<br /><br />If the former, you could rewrite the sentence: "The man, who didn't like goodbyes, said 'Hello.'", where the commas make perfect sense (at least to me, anyway!)Boneisthttps://www.blogger.com/profile/12879435303399136559noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-81040222626973089802010-11-05T11:18:46.934+00:002010-11-05T11:18:46.934+00:00I believe this issue was reported in Metalink as a...I believe this issue was reported in Metalink as a bug, though I can't find it anymore.<br /><br />When using an older (i.e. 9i) client, then a string with an odd number of single quotes fails with an ora-01756 (quoted string not properly terminated).<br />A string with an even number of single quotes will work as expected!theoahttps://www.blogger.com/profile/16822285145251788576noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-39076581798755900522010-11-05T10:59:16.905+00:002010-11-05T10:59:16.905+00:00I have the same issue, on my local machine it does...I have the same issue, on my local machine it doesn't work using SQL*Plus release 9. If I run the script on the database server using SQL*Plus 10 it works fine.Unknownhttps://www.blogger.com/profile/12599036240372485215noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-2650896736288860572010-11-05T10:53:56.482+00:002010-11-05T10:53:56.482+00:00crikeymo, we found that when using subquery factor...crikeymo, we found that when using subquery factoring (with xyz as (select...)) on a 10g db but our BA still had an 8i client!<br /><br />His client just complained about "expecting SELECT" or something along those lines.<br /><br />Was something that came to mind when reading #2Scott Wesleyhttps://www.blogger.com/profile/18106937181788036683noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-26585353218469238542010-11-05T10:41:06.122+00:002010-11-05T10:41:06.122+00:00On my local machine, I can't get it to work be...On my local machine, I can't get it to work because I have the Oracle 9 client installed, despite connecting to an Oracle 10 database. So it gets picked up by SQL*Plus or other client side tool as an error if there are an odd number of quotes. Works fine if I use the Oracle 10 SQL*Plus client on the server though.mikeybycrikeyhttps://www.blogger.com/profile/12638401174430918473noreply@blogger.comtag:blogger.com,1999:blog-8677649049588007585.post-4469862264632927662010-11-05T10:40:20.747+00:002010-11-05T10:40:20.747+00:00I also blogged about this today - uncannily a topi...I also <a href="http://triangle-circle-square.blogspot.com/2010/11/quoting-inside-literal-strings.html" rel="nofollow">blogged</a> about this today - uncannily a topic I had drafted for a few weeks ;-)<br /><br /><br />I've used this feature extensively in various flavours of 10g and never had any problems - can't comment on 11.Scott Wesleyhttps://www.blogger.com/profile/18106937181788036683noreply@blogger.com