Hi All,
In my CLOB data, I've the HTML contents with '&' character, it has a special meaning in Oracle, like it prompts to input data from the user, how do we suppress this, like we use Escape character in the LIKE operator as shown below? Could you please share your views? Thank you.
select to_clob('<html><body>Test Data &Parameter</body></html>') from dual;
with a(col1)
as
(select '<html><body>Test Data %Parameter</body></html>' from dual
union
select '<html><body>Second Row</body></html>' from dual)
select * from a
where col1 like '%\%%' escape '\';