number format issue [message #430262] |
Mon, 09 November 2009 17:00  |
shrinika
Messages: 306 Registered: April 2008
|
Senior Member |
|
|
Hello,
This may be very silly question. Is this(to_number(no,'999999')) wrong format?
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> create table yy(no number(8,2));
Table created.
SQL> insert into yy values(12.2);
1 row created.
SQL> select to_number(no,'9999.99') from yy;
TO_NUMBER(NO,'9999.99')
-----------------------
12.2
SQL> select to_number(no,'999999') from yy;
select to_number(no,'999999') from yy
*
ERROR at line 1:
ORA-01722: invalid number
SQL>
|
|
|
|
|