30 « March « 2016 « CodeThatAint

select distinct ac.name,ac.line
  from all_source ac
 where ac.OWNER ='DBOWNERNAME' and
       lower(ac.TEXT) like '%TABLE_NAME%';

formula to give you a comparison:

=AND(A2:A11=B2:B11)

Enter the formula by pressing Ctrl+Shift+Enter. If done correctly it will appear as the following:

{=AND(A2:A11=B2:B11)}

For a case-sensitive comparison, the equals operator will not work. Instead, the EXACT() function should be used.

{=AND(EXACT(A2:A11,B2:B11))}

CodeThatAint