Re: simple things
Date: 1996/11/09
Message-ID: <5630ah$10fc_at_watnews1.watson.ibm.com>#1/1
In <561kes$rin_at_news.xs4all.nl>, sdv_at_xs4all.nl (Simon Verzijl) writes:
>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';
>(so far so good)
>
>
>but this :
>
>select number from test where name=substr('simonblablablabla',1,5);
>
>doesn't return any rows.
>
>
>same goes for the following PL/SQL script (which was in fact the
>actual reason I started testing the above)
>
>create or replace
> procedure get_number(person in varchar2)
> is d_number integer;
> begin
> select number into d_number
> from test
> where name =person;
> end if;
> end;
>
>
>(Oracle version: Personal Oracle 7.2/ Oracle Workgroup Server 7.2)
>
>
>
>Simon
>
Interesting...
M.Landa Received on Sat Nov 09 1996 - 00:00:00 CET