If I have a nested query that contains a comment with an apostrophe (') in it, the beautifier alignment gets thrown off.
Example:
In the above example, the "from" and "where" lines are shifted to the right 1 space. Removing the apostrophe correctly right-aligns them with "select".
Strangely, it is only an issue within a nested query.
Thanks.
Example:
Code:
select *
from (select *
from dual
where dummy = 'X' -- this "'" (apostrophe) is causing an issue with the beautifier alignment
order by dummy)
In the above example, the "from" and "where" lines are shifted to the right 1 space. Removing the apostrophe correctly right-aligns them with "select".
Strangely, it is only an issue within a nested query.
Thanks.
Last edited: