The Numeric ROUND Function
The ROUND function performs a rounding operation on a numeric value based on the decimal precision specified. The value returned is rounded either up or down, depending on the numeric value of the significant digit at the specified decimal precision position. If the specified decimal precision is n, the digit significant to the rounding is found (n+ 1) places to the RIGHT of the decimal point. If it is negative, the digit significant to the rounding is found n places to the LEFT of the decimal point. If the numeric value of the significant digit is greater than or equal to 5, a “round up” occurs; otherwise, a ...
- CHAPTER 10 Single-Row and Conversion Functions
- from OCA/OCP Oracle Database 11g All-in-One Exam Guide with CD-ROM : Exams 1Z0-051, 1Z0-052, 1Z0-053
- Publisher: Oracle Press
- Released: August 2009
Revisit - Imp
Share this highlighthttp://www.safaribooksonline.com/a/ocaocp-oracle-database/1886/