tag:blogger.com,1999:blog-15861274.post452067979669871331..comments2023-09-18T11:14:24.509+01:00Comments on Oracle WTF: Concatenation, Concatenation, ConcatenationWilliam Robertsonhttp://www.blogger.com/profile/06976436975493102341noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-15861274.post-92197353825660509562011-04-08T09:47:45.444+01:002011-04-08T09:47:45.444+01:00It's very strange that "concat" and ...It's very strange that "concat" and "||" are used in the same expression.<br />But it's beautyful anyway :)<br /><br />Btw, I believe you'll enjoy this exception handler:<br />when others then <br /> rollback;<br /> SERRTEXT := [long string of concatenated parameters]<br /> insert into TR_DAG_FRM_RSV1_ERR_LOG( AUTHID, MSG_TEXT ) values ( user, SERRTEXT );<br /> update TR_DAG_FRM_RSV1_ERR_LOG set MSG_TEXT = MSG_TEXT || R.QUERY where AUTHID = user;<br /> commit;<br /> raise;<br />end;agathishttps://www.blogger.com/profile/11922508901474211744noreply@blogger.comtag:blogger.com,1999:blog-15861274.post-11090400997454516812011-03-26T12:51:52.593+00:002011-03-26T12:51:52.593+00:00Could have had more CONCAT functions if they'd...Could have had more CONCAT functions if they'd converted the '||' operator as well!<br /><br />I'm really not sure what that function gives you that '||' doesn't already do in a neater, shorter and easier to read manner.petercmoorehttps://www.blogger.com/profile/17366331102790168465noreply@blogger.comtag:blogger.com,1999:blog-15861274.post-67453627876176256392011-03-26T11:15:06.658+00:002011-03-26T11:15:06.658+00:00It must not do anything important, since no one ca...It must not do anything important, since no one cares whether it works or not:<br /><br />"exception when others then null;<br />means never having to say you're sorry."Stew Ashtonhttps://www.blogger.com/profile/10004507258457241890noreply@blogger.com