Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Problem for column defined as number(xx) returns as nnnnn.0 from an sql statement

Problem for column defined as number(xx) returns as nnnnn.0 from an sql statement

From: qdn <quocducnguyen_at_yahoo.com>
Date: Fri, 10 Nov 2000 13:06:40 GMT
Message-ID: <39e3032e.77876309@news-server.cox.rr.com>

We defined a table with several columns as number(11)

Upon executing a sql like: select * from mytable, we get xxxx.0 instead of what we expect: xxxx

The confusing part was that this only occurs SOMETIMES, most other times, we get xxxx

Is there a configuration file somewhere with Oracle where we can set the default format so that it would return the number without the decimal digit?

We rather not have to drop all the tables and redo them as number(11,0).

Any help would be greatly appreciated.

PS: Version 8.1.5? with WebLogic

quocducnguyen_at_yahoo.com Received on Fri Nov 10 2000 - 07:06:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US