--SYNTAX--DECODE (column name, number 1 to be searched, result 1 to be updated, number 2 to be searched, result 2 to be updated , number 3 to be searched, result 3 to be updated . . . . . . . . .

Friends,<BR><BR>I'm trying to write a select statement that ends like this:<BR><BR><pre class="ip_ubbcode_code_pre"><BR>and sc.customer_name in (DECODE(shipto,'0',sc ...

I’ve encountered an issue in the SQL Editor where syntax highlighting stops working for all subsequent code when using certain functions, such as PIVOT. Below is an example illustrating the problem: ...