Another beautifier problem

Against Oracle 10g, the beutifier munges the new quoted string literal as such:

Before:

Code:
v_sql : = 'and r2.ReceivedTime <= :AsOf' ||
  CASE
    WHEN handledeletedreadings = 2
    THEN
q'< and bit_ops.bitand(status,65536) = ' 0 ' >'
     ELSE ''
   END;
Beautified:

Code:
v_sql : = 'and r2.ReceivedTime <= :AsOf' ||
  CASE
    WHEN handledeletedreadings = 2
    THEN
q '< and bit_ops.bitand(status,65536) = ' 0 ' >'
     ELSE ''
   END;
Notice the space between the " q " and the " ' "
 
Back
Top