tag:blogger.com,1999:blog-1271763227002553835.post1998510888403370482..comments2024-03-26T08:42:34.744+01:00Comments on Notes on Oracle: Value Error and Invalid NumberAlex Nuijtenhttp://www.blogger.com/profile/06345615264010120428noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-1271763227002553835.post-36849991542145677192012-03-29T23:41:35.576+02:002012-03-29T23:41:35.576+02:00This looks very confusing to me!This looks very confusing to me!hot tubs for salehttp://www.discountspasdirect.com/noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-54186077496398828252011-07-19T19:06:57.984+02:002011-07-19T19:06:57.984+02:00of course!!! for that reason my program don't ...of course!!! for that reason my program don't work, now I can reprogram the code and see what happen, thanks for the help.Canadian Viagrahttp://www.xlpharmacy.com/noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-47231368555036314312011-03-20T19:17:41.092+01:002011-03-20T19:17:41.092+01:00SUPERB EXPLANATION :) Thanks a lot :)SUPERB EXPLANATION :) Thanks a lot :)Unknownhttps://www.blogger.com/profile/08876726150165997995noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-56935210260537512462009-05-29T10:57:24.977+02:002009-05-29T10:57:24.977+02:00Yes, thank youYes, thank youAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-29135847643168459992009-05-29T10:35:28.005+02:002009-05-29T10:35:28.005+02:00Of course, you are right. Using the "conversion" i...Of course, you are right. Using the "conversion" in the non-hint was a (maybe) wrong choice of words. The point I was trying to make is that this statement: <br />select 'a' into n from dual;<br />raises a VALUE_ERROR. The string ('a) is attempted to be converted into a NUMBER in PL/SQL, and not in SQL.<br />When you try to "do the right thing" and explicitly convert it to a NUMBER in SQL, using the TO_NUMBER function you get a different exception INVALID_NUMBER.<br />Does this clarify my choice of words - explicit and implicit conversion?Alex Nuijtenhttps://www.blogger.com/profile/06345615264010120428noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-11026623881281118822009-05-29T10:23:21.066+02:002009-05-29T10:23:21.066+02:00Yes, I see: No hint :-)
Nevertheless, why the comp...Yes, I see: No hint :-)<br />Nevertheless, why the comparison of a valid statement with an invalid one and where is the implicit conversion of the first statement?<br />You put in a sting ('a') and get a string 'a'. There's no conversion.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-30968842438854710352009-05-29T10:09:04.932+02:002009-05-29T10:09:04.932+02:00Well, it's not really a hint. Looks like a hint be...Well, it's not really a hint. Looks like a hint because of the /*+ ... */ notation, but it is not.<br />The reason I put these there was just to identify the individual SQL statements and find them in the trace file.Alex Nuijtenhttps://www.blogger.com/profile/06345615264010120428noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-44424041456151161062009-05-29T10:05:47.392+02:002009-05-29T10:05:47.392+02:00Don't understand your comparison between
select /...Don't understand your comparison between <br />select /*+ hint1 */ 'a'<br />with<br />select /*+ hint2 */ to_number('a')<br />Obviously I can select a string from dual, however I can't convert a string to number and that's independent of the hint.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-1957243386586437362009-02-12T08:37:00.000+01:002009-02-12T08:37:00.000+01:00No,... but you can probably guess which book it is...No,... but you can probably guess which book it is... ;-)Alex Nuijtenhttps://www.blogger.com/profile/06345615264010120428noreply@blogger.comtag:blogger.com,1999:blog-1271763227002553835.post-50061302928666966952009-02-12T08:19:00.000+01:002009-02-12T08:19:00.000+01:00Didn't you have to sign an NDA (No Damn Announceme...Didn't you have to sign an NDA (No Damn Announcements) agreement for proofreading ;-)Anonymousnoreply@blogger.com