Re: simple things

This is probably related to the fact that test.name is CHAR. Try using VARCHAR2.

Simon Verzijl wrote:
>
> 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
Received on Thu Nov 14 1996 - 00:00:00 CET