Re: More on ORA-01722

From: Kay Kanekowski <kay.kanekowski_at_web.de>
Date: Thu, 21 Mar 2013 00:47:03 -0700 (PDT)
Message-ID: <e124f30e-649e-4ad3-ba1a-b7cc8078a0ba_at_googlegroups.com>

a little testcase why i prefer datatype conversion on the left side: create table kk_num ( wert varchar2(10));

Tabelle wurde erstellt.

insert into kk_num values ('1');
insert into kk_num values ('1,0');
insert into kk_num values ('+1,0');
insert into kk_num values ('01');

select * from kk_num where wert = 1;

WERT

---

1
1,0
+1,0
01

select * from kk_num where wert = to_char(1);

WERT

---

1 Received on Thu Mar 21 2013 - 08:47:03 CET