Re: Significant Figures

Mitchell Ryan wrote:
>
> Mitchell Ryan wrote:
> >
> > Does any know of an Oracle function that handles significant figures?
> > Or does anyone know of an function that someone has written that I
> > can download that does this?
> >
>

ROUND(n,[m]) returns m rounded to m places, if m is omitted it's taken as 0. m can be negative to round places to the left of the decimal point.

TRUNC (n,[m]) is similar but it truncates i.e always rounds down.

• Ed Kulis 408-341-5561 Hal Computer Systems
• Sr. Oracle DBA ekulis_at_hal.com Campbell, CA 95008
• I would like it to be known that all opinions that are shown
• are exclusively my own, on my own, all my own.