Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Worksheet
Geoff Muldoon wrote:
> damorgan_at_psoug.org says...
>> beerora wrote: >>> I am using Foxpro to extract data from ORACLE9i. I am connected >>> through ODBC. One of the field in DB is number. When I retrieve the >>> data from DB by FOXPRO the result is not ROUNDER or TRUNCATED. But the >>> same query when I use in SQL Worksheet, the result is either ROUNDED or >>> TRUNCATED to one decimal point. >>> >>> E.g., if the value is 2345678.95 then it is rounded to 2345679.0 >>> if the value is 234567.23 then it is truncated to 234567.30 >>> >>> Can anyone help me why SQL worksheet behave this way? >> What do you want to do? Just use the appropriate function. >> >> SELECT TRUNC(<column_name>) or SELECT ROUND(<column_name>, <places>)
Don't have the product so if that is the question I can't comment.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Mon Dec 11 2006 - 17:44:35 CST