SQL> create table a1(id int,name varchar2(10));
Table created.
SQL> create table a2(id int,name varchar2(10));
Table created.
SQL> insert into a1 values(1,'a');
1 row created.
Commit complete.
SQL> insert into a2 values(100,'a'||CHR(13));
1 row created.
SQL> COMMIT;
Commit complete.
SQL> SELECT * FROM A1;
ID NAME
---------- ----------
1 a
SQL> SELECT * FROM A2;
ID NAME
---------- ----------
100 a
SQL> SELECT DUMP(NAME) FROM A1;
DUMP(NAME)
--------------------------------------------------------------------------------
Typ=1 Len=1: 97
Typ=1 Len=1: 97
SQL> select length(name) from a1;
LENGTH(NAME)
------------
1
--------------------------------------------------------------------------------
SQL> select dump(name) from a2;
DUMP(NAME)
Typ=1 Len=2: 97,13
SQL> select length(name) from a2;
LENGTH(NAME)
------------
2
SQL>
SQL>
SQL> select * from a1,a2
2 where a1.name=a2.name;
no rows selected
SQL> select * from a1,a2
2 where a1.name=replace(a2.name,CHR(13),'');
ID NAME ID NAME
---------- ---------- ---------- ----------
1 a 100 a