WITH c AS (SELECT 'abccdeeef' str FROM DUAL) SELECT REGEXP_REPLACE (str, '(.)\1+', '\1') ccid FROM c;
Mike On Fri, Jan 28, 2011 at 1:42 AM, Norbert Pürringer <[email protected]>wrote: > Hello, > > may you please help me to find a proper PL/SQL procedure to handle > following task: > > Input is a VARCHAR2 parameter. > > Output is a VARCHAR2 parameter. > > Take the VARCHAR2 parameter and delete all characters, if they are the > same as the previous character. > > Example: abccdeeef => abcdef > > Thank you very much, > Robert > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
