Learning Oracle SQL and PL/SQL
Tuesday, May 17, 2016
How to remove repeated character from string
By using regular experssion it is possible to remove repeated characters from string
Example
select
regexp_replace
('Tesstt'
,
'(.)\1+'
,
'\1'
)
from
dual
;
Result: Test
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment