tag:blogger.com,1999:blog-6427794798870474985.post7188163373062127913..comments2023-10-29T19:58:05.034+05:30Comments on Oracle Apps: How to remove new line characters and Tab's in the SQL outputSairam Goudhttp://www.blogger.com/profile/05683685602731756392noreply@blogger.comBlogger18125tag:blogger.com,1999:blog-6427794798870474985.post-84267264379367551252013-03-22T23:37:58.998+05:302013-03-22T23:37:58.998+05:30It works great.It works great.Anonymoushttps://www.blogger.com/profile/00568757871490739828noreply@blogger.comtag:blogger.com,1999:blog-6427794798870474985.post-58456201601205126942013-03-12T02:28:54.584+05:302013-03-12T02:28:54.584+05:30Appreciate the post. Sorted me out.Appreciate the post. Sorted me out.Anonymoushttps://www.blogger.com/profile/12304008505348609258noreply@blogger.comtag:blogger.com,1999:blog-6427794798870474985.post-82240781448966447592012-12-13T16:11:06.957+05:302012-12-13T16:11:06.957+05:30Hi Sairam,
A ton of thanks. God Bless you..!!
Re...Hi Sairam,<br /><br />A ton of thanks. God Bless you..!!<br /><br />Regards,<br />RKRKhttps://www.blogger.com/profile/10614080641116597799noreply@blogger.comtag:blogger.com,1999:blog-6427794798870474985.post-67674969134165258482012-10-30T22:03:50.042+05:302012-10-30T22:03:50.042+05:30Thank you... really helpfulThank you... really helpfulAnonymoushttps://www.blogger.com/profile/18312643043767212308noreply@blogger.comtag:blogger.com,1999:blog-6427794798870474985.post-18517796133303107452012-07-06T19:30:20.112+05:302012-07-06T19:30:20.112+05:30Whoa!It really worked well in my case, i was tryin...Whoa!It really worked well in my case, i was trying hard to find something like this.StrageMehttps://www.blogger.com/profile/01430189338413253086noreply@blogger.comtag:blogger.com,1999:blog-6427794798870474985.post-57043588817831136572012-07-06T19:29:30.216+05:302012-07-06T19:29:30.216+05:30Whoa!! it worked so well for my script where i was...Whoa!! it worked so well for my script where i was trying hard to get this.StrageMehttps://www.blogger.com/profile/01430189338413253086noreply@blogger.comtag:blogger.com,1999:blog-6427794798870474985.post-15764084500458872542012-07-03T03:35:05.818+05:302012-07-03T03:35:05.818+05:30Cool.. it works in all my scenarios...
Thanks dude...Cool.. it works in all my scenarios...<br />Thanks dude...Rajeshhttps://www.blogger.com/profile/15493880761641786570noreply@blogger.comtag:blogger.com,1999:blog-6427794798870474985.post-78103257951802329552012-06-29T14:17:29.752+05:302012-06-29T14:17:29.752+05:30thanks!! it fixes my problem . . . .thanks!! it fixes my problem . . . .Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6427794798870474985.post-34066023827651963482012-06-28T00:22:50.577+05:302012-06-28T00:22:50.577+05:30thanks! very helpfulthanks! very helpfulDavehttps://www.blogger.com/profile/11946701433928394443noreply@blogger.comtag:blogger.com,1999:blog-6427794798870474985.post-85798123374375830882012-06-14T14:05:45.691+05:302012-06-14T14:05:45.691+05:30also can use:
regexp_replace(comment, chr(9)||'...also can use:<br />regexp_replace(comment, chr(9)||'|'||chr(10)||'|'||chr(13), '')someonehttps://www.blogger.com/profile/07769071718135542314noreply@blogger.comtag:blogger.com,1999:blog-6427794798870474985.post-38730257996465462922011-12-20T16:10:58.995+05:302011-12-20T16:10:58.995+05:30Thank you so much... it's really saved me a lo...Thank you so much... it's really saved me a lot..<br />awesome job dude..!!!NarendraMuthumhttps://www.blogger.com/profile/15075050608481313407noreply@blogger.comtag:blogger.com,1999:blog-6427794798870474985.post-22130031313284613882011-12-20T16:05:21.302+05:302011-12-20T16:05:21.302+05:30This comment has been removed by the author.NarendraMuthumhttps://www.blogger.com/profile/15075050608481313407noreply@blogger.comtag:blogger.com,1999:blog-6427794798870474985.post-35909568222096404262011-05-25T00:44:46.613+05:302011-05-25T00:44:46.613+05:30Fantastic !Fantastic !Anonymoushttps://www.blogger.com/profile/14994328120997127081noreply@blogger.comtag:blogger.com,1999:blog-6427794798870474985.post-43721704777617099822011-03-02T09:41:46.721+05:302011-03-02T09:41:46.721+05:30Hi ...
I must say
Sairamgoud .This was a Fine piec...Hi ...<br />I must say<br />Sairamgoud .This was a Fine piece of work. <br /><br />:-)<br /><br />Cheers<br />NaseerNaseeruddinhttps://www.blogger.com/profile/01106754208005456790noreply@blogger.comtag:blogger.com,1999:blog-6427794798870474985.post-52003863809098932922011-02-19T03:21:20.529+05:302011-02-19T03:21:20.529+05:30Wonderful post :) it helped me fruitfully :) Tons ...Wonderful post :) it helped me fruitfully :) Tons of thanksSenthyLhttps://www.blogger.com/profile/04994823694512780032noreply@blogger.comtag:blogger.com,1999:blog-6427794798870474985.post-73780702044815254312010-03-26T17:43:19.397+05:302010-03-26T17:43:19.397+05:30Its really works
.
.
Tnx dudeIts really works<br />.<br />.<br />Tnx dudeAdminhttps://www.blogger.com/profile/04005337343089815553noreply@blogger.comtag:blogger.com,1999:blog-6427794798870474985.post-22987129369110492462009-10-19T22:15:18.888+05:302009-10-19T22:15:18.888+05:30Hi
That is great for replacing. How would I search...Hi<br />That is great for replacing. How would I search a column to find all the new line characters (made from a windows PC) first before replacing them? <br />ThanksDBAhttps://www.blogger.com/profile/13364685777001012225noreply@blogger.comtag:blogger.com,1999:blog-6427794798870474985.post-30733646441603848222009-09-26T19:52:11.876+05:302009-09-26T19:52:11.876+05:30This is very useful command.It help me out.ThanksThis is very useful command.It help me out.Thanksnithttps://www.blogger.com/profile/17016301057306437457noreply@blogger.com