tag:blogger.com,1999:blog-3060148920065298017.post7229087560914242182..comments2023-12-28T17:33:10.928+03:00Comments on Volder's Oracle Notes: Removing duplicate elements from the stringVolderhttp://www.blogger.com/profile/15557750923919600413noreply@blogger.comBlogger20125tag:blogger.com,1999:blog-3060148920065298017.post-17494853624228914912016-07-26T18:54:40.272+03:002016-07-26T18:54:40.272+03:00Hey there, great stuff!! Question, how about remov...Hey there, great stuff!! Question, how about removing duplicates when the last letter of the word is the same letter of the next word? <br /><br />For instance: 4YR,CAS,SUB1<br /><br />In this instance, the following results: 4YR,CASUB1<br /><br />This happens because of the 'S' at the end of 'CAS' and at the beginning of 'SUB1'; how can you combat this? I've looked ALL OVER the internet and it seems like it's not doable unless you create a function and I'd like to avoid that if possible.<br /><br />Thanks!Caloveechyhttps://www.blogger.com/profile/07578862495081058784noreply@blogger.comtag:blogger.com,1999:blog-3060148920065298017.post-5380854693005978632013-01-21T21:02:12.539+04:002013-01-21T21:02:12.539+04:00nice explanation..and very helpful..thank younice explanation..and very helpful..thank youAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3060148920065298017.post-76875430623571336382012-08-30T17:15:40.414+04:002012-08-30T17:15:40.414+04:00it's really working is pl\sql code to do the s...it's really working is pl\sql code to do the sameAruhttps://www.blogger.com/profile/16296343919778499659noreply@blogger.comtag:blogger.com,1999:blog-3060148920065298017.post-8364599642713006722012-05-02T23:12:50.070+04:002012-05-02T23:12:50.070+04:00Thank you for this, the fastest and least resource...Thank you for this, the fastest and least resource consuming solution.<br /><br />Thank you again!awshttps://www.blogger.com/profile/04622853439409861784noreply@blogger.comtag:blogger.com,1999:blog-3060148920065298017.post-90102297612777061682011-11-14T14:50:15.191+04:002011-11-14T14:50:15.191+04:00This was very usefulfulful!!! Thank you very very ...This was very usefulfulful!!! Thank you very very much much Sir.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3060148920065298017.post-18872813224887020612011-10-25T11:46:24.432+04:002011-10-25T11:46:24.432+04:00Hi Volder,
helpful article!
I was using your las...Hi Volder,<br /><br />helpful article!<br /><br />I was using your last Query for removing duplicates in a string with delimiter. It works fine as a SQL<br />but when i tried using it in a store Procedure , i get compilation error as "(S42) Expecting: ) , CONNECT CROSS FOR FULL GROUP HAVING INNER INTERSECT JOIN LEFT MINUS NATURAL ORDER RIGHT START UNION WHERE" at the following line :<br /><br />dimension by (0 dim).<br /><br />Couldn't find much on internet about it. Please see if u can help!<br /><br />Thanks,<br />RajatRAJAT ARORAhttps://www.blogger.com/profile/04419807730082573902noreply@blogger.comtag:blogger.com,1999:blog-3060148920065298017.post-28625213983527913322011-07-20T15:03:34.730+04:002011-07-20T15:03:34.730+04:00Thanks for this very helpful solution.
Regards
GC ...Thanks for this very helpful solution.<br />Regards<br /><b>GC Shekar</b>gcshekar@yahoo.comhttp://www.mansoft.co.innoreply@blogger.comtag:blogger.com,1999:blog-3060148920065298017.post-6670310872824599142010-05-14T05:18:16.908+04:002010-05-14T05:18:16.908+04:00thank you for your great posts. i am trying to rem...thank you for your great posts. i am trying to remove only consecutive duplicates from a + delimited string like 'ipd_vupp_prem3_8_d_d_es+ipd_vupp_prem3_8_d_d_es+ipd_vupp_prem3_9_d_d_es+ipd_vupp_prem3_8_d_d_es' where i want the output to look like 'ipd_vupp_prem3_8_d_d_es+ipd_vupp_prem3_9_d_d_es+ipd_vupp_prem3_8_d_d_es'arulnoreply@blogger.comtag:blogger.com,1999:blog-3060148920065298017.post-19857500073792915792009-04-24T18:50:00.000+04:002009-04-24T18:50:00.000+04:00thanksthankshello_earthhttps://www.blogger.com/profile/03460973441971470227noreply@blogger.comtag:blogger.com,1999:blog-3060148920065298017.post-6450446578225737482009-03-17T14:31:00.000+03:002009-03-17T14:31:00.000+03:00having information you gave - sorry, I cannot.with...having information you gave - sorry, I cannot.<BR/><BR/>with such a question you better go to Oracle forum - where you will for sure get the answer.Volderhttps://www.blogger.com/profile/15557750923919600413noreply@blogger.comtag:blogger.com,1999:blog-3060148920065298017.post-11521763774552266362009-03-17T13:57:00.000+03:002009-03-17T13:57:00.000+03:00I want to use the last sql statement (WITH t) in t...I want to use the last sql statement (WITH t) in the Stored Procedure. But it is giving error. Can you tell me how to do that?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3060148920065298017.post-52773682629918563482009-03-17T13:21:00.000+03:002009-03-17T13:21:00.000+03:00you need to make some amendments in regex - instea...you need to make some amendments in regex - instead of comma to use a slash.<BR/>I'm sure you will find the way - if you know what regular expressions are.Volderhttps://www.blogger.com/profile/15557750923919600413noreply@blogger.comtag:blogger.com,1999:blog-3060148920065298017.post-54225765394541637472009-03-17T12:47:00.000+03:002009-03-17T12:47:00.000+03:00if i want to use '/' instead of ',' as a separator...if i want to use '/' instead of ',' as a separator then what I have to do for that...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3060148920065298017.post-61915545962954571892008-09-08T14:21:00.000+04:002008-09-08T14:21:00.000+04:00This one was really good and very helpful. I have ...This one was really good and very helpful. I have a similar requirement and now I am trying to incultate the same trick in my sql.Just mehttps://www.blogger.com/profile/13217795125698966639noreply@blogger.comtag:blogger.com,1999:blog-3060148920065298017.post-27096549343920811272008-02-02T04:08:00.000+03:002008-02-02T04:08:00.000+03:00I was searching for it and you had it.Good Job in ...I was searching for it and you had it.<BR/><BR/>Good Job in explaining the details.<BR/><BR/>Thanks for the blog.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3060148920065298017.post-17579618906707311152007-10-20T14:31:00.000+04:002007-10-20T14:31:00.000+04:00Hi Volder,Good to see you started blogging too. Kn...Hi Volder,<BR/><BR/>Good to see you started blogging too. Knowing the quality of your posts on the SQL and PL/SQL forum, I look forward to see more of them here.<BR/><BR/>And if you are posting frequently, then I'll even put a link from my own blog to here :-)<BR/><BR/>Regards,<BR/>Rob.Rob van Wijkhttps://www.blogger.com/profile/00499478359372903250noreply@blogger.comtag:blogger.com,1999:blog-3060148920065298017.post-20597559699454656232007-10-08T10:21:00.000+04:002007-10-08T10:21:00.000+04:00Hi Volder, Glad to see you have your own blog now!...Hi Volder, <BR/><BR/>Glad to see you have your own blog now! I'm looking forward to following it. I'm sure there are lots of clever and insightful solutions yet to come, just like your OTN posts. :-)<BR/><BR/>--<BR/>Joe Fuda<BR/><A HREF="http://www.sqlsnippets.com/" REL="nofollow">SQL Snippets</A>SnippetyJoehttps://www.blogger.com/profile/14976294759055735163noreply@blogger.comtag:blogger.com,1999:blog-3060148920065298017.post-25348172399221243492007-10-05T00:43:00.000+04:002007-10-05T00:43:00.000+04:00Very good explanation. Really appreciate your answ...Very good explanation. Really appreciate your answers on OTN.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3060148920065298017.post-18641549908201908062007-10-04T17:09:00.000+04:002007-10-04T17:09:00.000+04:00This comment has been removed by the author.Andrey Ermakovhttps://www.blogger.com/profile/08360303685304624259noreply@blogger.comtag:blogger.com,1999:blog-3060148920065298017.post-74121067772614958752007-10-04T17:07:00.000+04:002007-10-04T17:07:00.000+04:00Hi, countryman!:)))I watching for your posts in or...Hi, countryman!:)))<BR/>I watching for your posts in oracle.com and sql.ru:)<BR/>And I learn from this posts. Thank you, Volder!<BR/>You are right that you made this blog, so to hold!;) Please, forgive me for my english.<BR/>P.S. xymboAndrey Ermakovhttps://www.blogger.com/profile/08360303685304624259noreply@blogger.com