Hello I am working to find difference between the core code my company has produced as product and code that our client database contains. I am doing this with Beyond Compare. At some point along the way our client has used a different IDE to look at code and recompile it. The problem is that the only difference is in the create or replace statement being sent to Oracle.
So my company's source looks like:
create or replace trigger Trigger_tg_1
And the customers compiled source looks like:
create or replace trigger "SCHEMA"."TRIGGER_TG_1"
Both of these are the same to Oracle but are flagged as a difference in Beyond Compare. How would I write a regular expression to ignore these differences?