Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Worksheet
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>)
Daniel,
I think the OP is wanting the reverse, setting the format mask in SQL Worksheet for a higher/not limited level of precision than his current defaults are providing.
GM Received on Mon Dec 11 2006 - 16:09:20 CST