Start a new topic

format difference.... why?

[This topic is migrated from our old forums. The original author name has been removed]

Same SQL, only difference is the comment: WITH even_numbers AS ( SELECT 2 FROM dual UNION ALL SELECT 4 FROM dual ) , odd_numbers AS ( SELECT 1 FROM dual UNION ALL SELECT 3 FROM dual ) SELECT * FROM even_numbers UNION SELECT * FROM odd_numbers; WITH even_numbers AS -- comment ( SELECT 2 FROM dual UNION ALL SELECT 4 FROM dual ) , odd_numbers AS ( SELECT 1 FROM dual UNION ALL SELECT 3 FROM dual ) SELECT * FROM even_numbers UNION SELECT * FROM odd_numbers; When the comment is in the SQL, the name odd_numbers is no longer at the start of the line. Could this be fixed?

[This reply is migrated from our old forums.]

Re: format difference.... why?
Hi Ronald, Yes, that looks odd. We will have a look at it. Best Regards, Hans
[This reply is migrated from our old forums.]

Re: format difference.... why?
Ronald, This is now fixed in the 9.1.3 version. http://www.dbvis.com/download/ Regards Roger