Compare User Objects.

[admin]

Is it possible to have an option to ignore certain characters like whitespaces, quotations, etc. in "Compare User Objects"?

Thanks.
Andrew

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[admin]

Are you going to add that feature to the upcoming version 8?
So far I cannot find it in PL/SQL Developer 8 Beta.

Thanks.
Andrew

 

[Marco Kalter]

This has not yet been added in 8.0 (though it does implicitly ignore quotes in object names). It's still on the list though.

 

[Andrew Lacwik]

So can we expect "Ignore Quotes in Object Name" (related to Oracle Data Pump import) in Compare User Objects in PSD version 9? I am not sure if it has been already included in beta or not...

Thanks.

 

[Andrew Lacwik]

...also "Ignore Case" when two object compared...

 

[Marco Kalter]

Yes, both are added in 9.0. Quotes are ignored when the "Ignore white space" option is enabled, and case is ignored when the "Ignore case" option is enabled on the "Options" tab page.

 

[Andrew Lacwik]

Great! Thanks Marco.

 

[Andrew Lacwik]

>>>>>>>>>>>>>>>>>>>>>
Yes, both are added in 9.0. Quotes are ignored when the "Ignore white space" option is enabled, and case is ignored when the "Ignore case" option is enabled on the "Options" tab page.
>>>>>>>>>>>>>>>>>>>>
Apparently quotes are not ignored when option "Ignore white space in PL/SQL code" is enabled in "Options" tab in PL/SQL Developer 9. For example lines:
CREATE OR REPLACE FUNCTION "AGE2DATE" (dBirth IN DATE,nAge IN NUMBER) RETURN DATE AS
and
CREATE OR REPLACE FUNCTION Age2Date(dBirth IN DATE,nAge IN NUMBER) RETURN DATE AS
show differences for double quotes in line 1. They should be reported as identical.

 

[Marco Kalter]

Did you also enable the "Ignore case" option?

 

[Andrew Lacwik]

It looks like it works partially. It works for Packages. However, it does not work for Functions and Procedures - please see my previous reply with function definition as a sample. Even with all 3 options checked, i.e. "Ignore case...", "Ignore whitespace...", "Ignore comments..." in "Compare User Objects" - it still does not work for functions and procedures as expected.

Regards,

 

[Marco Kalter]

I literally tried your Age2Date example and it works fine. Note that if there are other differences in the function, the ExamDiff difference viewer that is packaged with PL/SQL Developer cannot ignore quotes or comments. It can only ignore case and white space.