Re: number and varchar

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 14 Dec 2000 06:39:25 +0100
Message-ID: <91b7e6$3jf4g$3@ID-62141.news.dfncis.de>

If it is a varchar (which you shouldn't use, use varchar2 instead) you need to enclose it in single quotes.
Right now apparently there is implicit conversion to number, which means the leading zeros are dropped.
The definition of the table in the other schema simply *must* be different. You should always write your statements in such a way *implicit* conversion is avoided.

Hth,

Sybrand Bakker, Oracle DBA

<eastking_at_my-deja.com> wrote in message news:919dj1$qvj$1_at_nnrp1.deja.com...
> hello, every one here.
>
> I have two schema in my database Oracle8.0.6/solaris.
>
> I run following sql in both of schemas.
>
> desc t_order
>
> orderCd varchar(10);
> ...
>
> select 1 from t_order where orderCd = 000000001;
>
> in first schema , it returned
>
> no record fetched.
>
> in another schema, it returned
>
> ORA-01722 ....
>
> Who can explain why it happend and how can I solute this problem.
>
> Thanks a lot.
>
>
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Wed Dec 13 2000 - 23:39:25 CST