Little bit more example:
declare
str_template varchar2(256);
str_translate varchar2(256);
begin
..
str_template := some_create_tmpl(source_str, ...);
str_translate := some_create_pattern(source_str, ...);
..
res_string := translate(source_str,
str_template,
str_template);
..
end;




Reply With Quote