Chris Fischer
Member
Against Oracle 10g, the beutifier munges the new quoted string literal as such:
Before:
Beautified:
Notice the space between the " q " and the " ' "
Before:
Code:
v_sql : = 'and r2.ReceivedTime <= :AsOf' ||
CASE
WHEN handledeletedreadings = 2
THEN
q'< and bit_ops.bitand(status,65536) = ' 0 ' >'
ELSE ''
END;
Code:
v_sql : = 'and r2.ReceivedTime <= :AsOf' ||
CASE
WHEN handledeletedreadings = 2
THEN
q '< and bit_ops.bitand(status,65536) = ' 0 ' >'
ELSE ''
END;