Re: Strange SQL ?

From: Rexx <nebacar_nospam_at_eunet.yu>
Date: Wed, 23 Feb 2000 19:38:37 +0100
Message-ID: <8919g8$4ks$1@SOLAIR2.EUnet.yu>

Sorry, I remember. Implict conversion!!

--

---

Remove nospam from address

nebacar_at_eunet.yu

---

Rexx <nebacar_nospam_at_eunet.yu> wrote in message news:890p99$kia$2_at_SOLAIR2.EUnet.yu...
> Sorry for my bad english
>
> I have two Oracle 7.3 DB domm and domb with the same table
> dom.zp_broj_racuna on both db. Column BROJ_RACUNA is the same NOT NULL
> VARCHAR2(11). But when I do select command behavior is different as is on
> listing:
> How is it possible?
>
> on DB domb:
>
> SQLWKS> connect dom/dom_at_domb;
> Connected.
> SQLWKS> desc dom.zp_broj_racuna
> Column Name Null? Type
> ------------------------------ -------- ----
> ZAPISNIK_SEQ NOT NULL NUMBER(8)
> SIF_POSLOV NOT NULL NUMBER(2)
> BROJ_RACUNA NOT NULL VARCHAR2(11)
> IND_NOVI NOT NULL VARCHAR2(1)
> UPLATA_DIN NUMBER(18,2)
> STORNO_ID NUMBER(8)
> P_DATE DATE
>
> SQLWKS> select * from dom.zp_broj_racuna where broj_racuna='9';
>
> ZAPISNIK_S SIF_POSLOV BROJ_RACUNA I UPLATA_DIN STORNO_ID P_DATE
> ---------- ---------- ----------- - ---------- ---------- ---------
> 3 2 9 N 0
> 1 row selected.
>
> SQLWKS> select * from dom.zp_broj_racuna where broj_racuna=9;
>
> ZAPISNIK_S SIF_POSLOV BROJ_RACUNA I UPLATA_DIN STORNO_ID P_DATE
> ---------- ---------- ----------- - ---------- ---------- ---------
> ORA-01722: invalid number <=======
> ?????????????????????????????????????????
>
>
> on DB domm
>
>
>
> SQLWKS> connect dom/dom_at_domm;
>
> Connected.
>
> SQLWKS> desc dom.zp_broj_racuna
>
> Column Name Null? Type
> ------------------------------ -------- ----
> ZAPISNIK_SEQ NOT NULL NUMBER(8)
> SIF_POSLOV NOT NULL NUMBER(2)
> BROJ_RACUNA NOT NULL VARCHAR2(11)
> IND_NOVI NOT NULL VARCHAR2(1)
> UPLATA_DIN NUMBER(18,2)
> STORNO_ID NUMBER(8)
> P_DATE DATE
> SQLWKS> select * from dom.zp_broj_racuna where broj_racuna='9';
> ZAPISNIK_S SIF_POSLOV BROJ_RACUNA I UPLATA_DIN STORNO_ID P_DATE
> ---------- ---------- ----------- - ---------- ---------- ---------
> 3 2 9 N 0
> 1 row selected.
>
> SQLWKS> select * from dom.zp_broj_racuna where broj_racuna=9;
>
> ZAPISNIK_S SIF_POSLOV BROJ_RACUNA I UPLATA_DIN STORNO_ID P_DATE
> ---------- ---------- ----------- - ---------- ---------- ---------
> 3 2 9 N 0
> 1 row selected. <==============
> !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
> --
>
>
>
>
> *********************************************
> Remove nospam from address
>
> nebacar_at_eunet.yu
> *****************************************
>
>
>
Received on Wed Feb 23 2000 - 12:38:37 CST