Have you ever wanted to replace a character in a string just by position? I needed this the other day and IMHO there is no way in Oracle PL\/SQL to do this, so I decided to write this my self.<\/p>\n
<\/p>\n
It is really simple code and it probably needs improvement but it works for now and I think it is rather simple. Any improvement suggestions are of course very welcome in the comments.<\/p>\n
CREATE OR REPLACE FUNCTION<\/font> replacepos Have you ever wanted to replace a character in a string just by position? I needed this the other day and IMHO there is no way in Oracle PL\/SQL to do this, so I decided to write this my self.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,5],"tags":[],"class_list":["post-519","post","type-post","status-publish","format-standard","hentry","category-oracle","category-plsql"],"_links":{"self":[{"href":"https:\/\/blog.bar-solutions.com\/index.php?rest_route=\/wp\/v2\/posts\/519","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.bar-solutions.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.bar-solutions.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.bar-solutions.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.bar-solutions.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=519"}],"version-history":[{"count":0,"href":"https:\/\/blog.bar-solutions.com\/index.php?rest_route=\/wp\/v2\/posts\/519\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.bar-solutions.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=519"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.bar-solutions.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=519"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.bar-solutions.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=519"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n
<\/font><\/font>( source_in <\/font>IN VARCHAR2
\n
<\/font> , replacechar_in<\/font> IN VARCHAR2
\n
<\/font> , position_in<\/font> IN NUMBER) RETURN VARCHAR2 IS
\n
<\/font> l_returnvalue<\/font> VARCHAR2<\/font>(32767);
\n
<\/font>BEGIN
\n
<\/font> — copy from the source string up to, but not including,
\n
— the character position
\n
— to be replaced
\n
<\/font> l_returnvalue := substr( str1 => source_in
\n
, pos => 1
\n
, len => position_in – 1);
\n
<\/font> — add the replacement character
\n
— just a single character, but more can be sent in,
\n
— so substring the parameter
\n
<\/font> l_returnvalue := l_returnvalue ||
\n
substr( str1 => replacechar_in
\n
, pos => <\/font><\/font>1
\n
, len => 1);
\n
<\/font> — copy the rest of the source string
\n
<\/font> l_returnvalue := l_returnvalue ||
\n
substr( str1 => source_in
\n
, pos => position_in + 1);
\n
<\/font> RETURN<\/font> l_returnvalue;
\n
<\/font>END<\/font> replacepos;<\/font><\/font><\/p>\n","protected":false},"excerpt":{"rendered":"