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

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