How do i replace ampersand in a string with &?
DECLARE
l_string VARCHAR2(1000):='AB&CD';
BEGIN
SELECT REPLACE(l_string,'&','&\amp;') INTO l_string FROM dual;
DBMS_OUTPUT.PUT_LINE('l_string = ' || l_string);
END;
Asked
Active
Viewed 417 times
0
-
2What's the goal here? If you're generating HTML or XML from plain text, the `&` symbol isn't the only thing to care about. – Álvaro González Jan 17 '22 at 10:22
-
Need to temporarily replace & to create xml from the string – PTK Jan 17 '22 at 10:32
-
1Your code [works](https://dbfiddle.uk/?rdbms=oracle_11.2&fiddle=a7d1e61dc2176fc91940dfcfbc0a06ab). So what is the problem? – sticky bit Jan 17 '22 at 10:35
-
when i run it , i get a prompt asking for value of CD and when i do not enter any value and run it, CD is lost. I am running this on SQL developer – PTK Jan 17 '22 at 10:36
-
1Execute `set define off` before running that code. – Littlefoot Jan 17 '22 at 10:37
-
This code is inside a stored procedure . Cannot use set define off. – PTK Jan 17 '22 at 14:36
-
So you get prompted when you compile it, not when you run it. Two different things. Set define off before compiling it. – William Robertson Jan 17 '22 at 19:21
1 Answers
1
encode
select dbms_xmlgen.convert('"ab&cd < ef"') from dual;
and decode
select dbms_xmlgen.convert('"ab&cd < ef"',1) from dual;
difr
- 21
- 3