SQL & PL/SQL

Hi All,

Query:

SELECT P.TEXT,S.TEXT,P.LINE,S.LINE,LENGTH(P.TEXT),LENGTH(S.TEXT), LENGTH(REPLACE(P.TEXT,' ','')), LENGTH(REPLACE(S.TEXT,' ',''))

            FROM all_source p,all_source@LINK_TST.WORLD s

           WHERE p.TYPE = 'FUNCTION'

             AND p.owner = 'ASAP'

            AND P.OWNER=S.OWNER AND P.TYPE=S.TYPE AND P.LINE=S.LINE AND

            P.NAME=S.NAME AND

            AND LENGTH(TRIM(P.TEXT)) <> LENGTH(TRIM(S.TEXT));

Clarification:

This query returns the  mismatch line as a result.

1 line of a function is resulted  on the query, while seeing both text values are similar.

   1 used TRIM function doesnt works TRIM(text) <> TRIM (text)

    2.LENGTH(TRIM(P.TEXT)) <> LENGTH(TRIM(S.TEXT));

    3.used REPLACE function doesnt works  LENGTH(replace(P.TEXT, ' ')) <> LENGTH(replace(S.TEXT,' '));

I have verified that one function has extra invisible character in the text column which causes the query to retun incorrect value.

how to exclude the invisible character in query?

Thanks,

Senthur