Home -> Usenet -> c.d.o.tools -> QUESTION when format TO_CHAR(xxx,'0999')(B

QUESTION when format TO_CHAR(xxx,'0999')(B

From: T.TAKAHASHI(B <tatsuyuki_t_at_pop11.odn.ne.jp>
Date: Tue, 23 Mar 1999 22:12:09 +0900
Message-ID: <7d83ta$b2p$1_at_nw031.infoweb.ne.jp> 





Hi,



 SQL> desc WMROKMPJ

 RKBAN                           NOT NULL NUMBER(3)
 RKKMK                                    NUMBER(4)
 RKHJY                                    NUMBER(4)
 RKPRJ                                    VARCHAR2(6)


SQL> 



SQL> SELECT * from WMROKMPJ;



     RKBAN      RKKMK      RKHJY    RKPRJ



---------- ---------- ---------- ------




         1       6481          90              777711



SQL> SELECT to_char(RKHJY,'0000') from WMROKMPJ;
When above statement excute result follow. 



TO_CH




0090 


      $B",(B



WHAT IS position 5-chraracter?



SQL> SELECT length(to_char(RKHJY,'0000')) FROM WMROKMPJ;



LENGTH(TO_CHAR(RKHJY,'0000'))




                                             5





WHY result is 5 ?



please help me ! 
Received on Tue Mar 23 1999 - 14:12:09 CET












Original text of this message