simple things
From: Simon Verzijl <sdv_at_xs4all.nl>
Date: 1996/11/09
Message-ID: <561kes$rin_at_news.xs4all.nl>#1/1
Date: 1996/11/09
Message-ID: <561kes$rin_at_news.xs4all.nl>#1/1
Can anyone tell me why this simplest query doesn't work ? :
create table test (name char(20), number decimal(3) );
insert into test values ('simon', 100);
select number from test where name='simon';
but this :
select number from test where name=substr('simonblablablabla',1,5);
(so far so good)
doesn't return any rows.
(Oracle version: Personal Oracle 7.2/ Oracle Workgroup Server 7.2)
Simon Received on Sat Nov 09 1996 - 00:00:00 CET