Yes, but how about the non-functional diffs such like line breaks, upper/lowercase itens, white spaces and alike ? How I could tell to SQL DEVELOPER ignore such differences in the comparision ?

Regards,

J. Chiappa

P.S.: just to add, when I spoke in DBMS_METADATA I was thinking in the lines of https://stackoverflow.com/questions/39911386/sql-regex-challenge-puzzle-how-to-remove-comments-from-sql-code-by-using-sql-q - of course, I would change the regex manipulations to take account of white spaces and upper/lowercases : if some option exists inside SQL DEVELOPER to get the same results please tell us...

Quoted strings diffs must be considered differences, but Yes, it´s not a simple logic...
SQL DEVELOPER have some internal facilities/resources to do it, for sure : for example, if I set in the code formatting options Identifiers case and Keywords case to UPPER (menu Tools, item Preferences, then inside Code Editor option Format) I will get the desired effect , ie, change my text :

declare
xxx varchar2(10) := 'Hello';
begin
XXX := 'ABC';
END;

DECLARE
XXX VARCHAR2(10) := 'hello';
Begin
xxx := 'xyz';
END;


to :


DECLARE
XXX VARCHAR(10) := 'Hello';
BEGIN
XXX := 'ABC';
END;

DECLARE
XXX VARCHAR2(10) := 'hello';
BEGIN
XXX := 'xyz';
END;

"escaping"/disconsidering the quoted strings as desired... But I was totally unable to use this features inside Code Comparision, and other necessities (such as remove extra whitespaces and linebreaks) were not found (by me) in the Code Format and/or Code Comparision options : due to this I opted for 'manual' procedures, such as extract the code via DBMS_METADATA and manipulate it with regexp, string functions and alike...
If really the task can´t be done inside SQL DEVELOPER, I will need to write something by myself, I think... But let me say thank you for confirming it...

Regards,

Chiappa