How to handle the '& amp;' symbol in Oracle SQL statements

How to handle the '&' symbol in Oracle SQL statements is automatically escaped if the '&' symbol appears in the SQL statement; the value of the string to be followed after the & symbol is required. For example, update tablename set columnName = 'HTTP: // www.g.cn/cv2.jsp? Spid = 222 & cid = 333 '; when you perform this operation, Oracle will prompt Enter value for cid: The reason is that the & Symbol in Oracle is used as an escape character. Solution: Use the Oracle string processing function chr for processing. Chr (38) indicates & Symbol Rewriting: update tablename set columnName = 'HTTP: // www.g.cn/cv2.jsp? Spid = 222 '| chr (38) | 'cid = 333'; this may be the case when some signed formats of html are stored in the database, if the encoding of some symbols is unknown, you can use the following method to query: select ascii ('&') from dual;