VARCHAR2字段关联

来源：互联网发布：克拉默法则知乎编辑：程序博客网时间：2024/06/05 17:25

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 aSQL> SELECT * FROM A2;ID NAME---------- ----------       100 aSQL> SELECT DUMP(NAME) FROM A1;DUMP(NAME)--------------------------------------------------------------------------------Typ=1 Len=1: 97Typ=1 Len=1: 97SQL> select length(name) from a1;LENGTH(NAME)------------   1--------------------------------------------------------------------------------SQL> select dump(name) from a2;DUMP(NAME)Typ=1 Len=2: 97,13SQL> select length(name) from a2;LENGTH(NAME)------------   2SQL> SQL> SQL> select * from a1,a2  2  where a1.name=a2.name;no rows selectedSQL> select * from a1,a2  2   where a1.name=replace(a2.name,CHR(13),'');ID NAME       ID NAME---------- ---------- ---------- ---------- 1 a     100 a

0 0