How to escape ® and ™ characters to its character and numeric entity like ® and ™ in a query

For example, if the data in a column is

`Descp

---

Comprhensive review ® `

how to retrieve the data as

Comprhensive review &am开发者_开发知识库p;reg ;

or

Comprhensive review ® ;

---

the replace function replace(input_str, tm_str, '&trade') can be nested. You'll need one call for each.

In Sqlplus you'll want to set scan off.