Re: sql

From: Michel Cadot <micadot_at_netcourrier.com>
Date: 2000/08/08
Message-ID: <8mp1io$698$1@s1.read.news.oleane.net>#1/1

Because of the space in first position:
v815> select to_char(257,'0XXXXX') from dual;

TO_CHAR

---

 000101

1 row selected.

v815> select hextoraw(to_char(257,'0XXXXX')) from dual; select hextoraw(to_char(257,'0XXXXX')) from dual

                *

ERROR at line 1:
ORA-01465: invalid hex number

v815>
v815> select hextoraw(ltrim(to_char(257,'0XXXXX'))) from dual;

HEXTORAW

---

000101

1 row selected.

--
Have a nice day
Michel


Marcin Buchwald <velvet_at_gazeta.pl> a écrit dans le message : 398FFAED.ADD6E59D_at_gazeta.pl...


>

> select to_char(257,'0XXXXX') from dual;

> select hextoraw('000101') from dual;

> select hextoraw(to_char(257,'0XXXXX')) from dual;

>

> what is the reason that third statement fails ?

Received on Tue Aug 08 2000 - 00:00:00 CDT