Trailing blanks in Views can lead to confusing results in "Compare User Objects"

Bernhard S

Member³
When you have a view with trailing blanks and compare it to one with non-trailing blanks, PL-SQL-Developer will report a difference. That happens also when you check in options to "Ignore white space in PL/SQL code". However when you try to look at the details of this difference, ExamDiff shows that files are identical until you uncheck in setting to "Ignore all white space in lines". PL/SQL Developer should also have an option to ignore trailing blanks in views when comparing and warn about possibly contradicting white-space settings "Compare User Objects" and ExamDiff.
 
The "Ignore white space PL/SQL code" option only applies to PL/SQL code, and not to views. I have added this to the list of enhancement requests.
 
Back
Top