Importance of SQL Character Functions in Oracle Database Hello Everyone, Today we will discuss about SQL functions in Oracle which plays important role in writing SQL queries. Before Starting to read this blog I suggest you to please go through my previous basic SQL blog for your reference. We will discuss the below Functions in today’s blog. 1. ROUND 2. TRUNC 3. CEIL and FLOOR 4. SIGN AND ABS 5. NVL and NVL2 Let’s discuss Round Function in SQL: ROUND function is used to round a numeric value to a specified precision. If the value is less than 5, the function rounds down. If the value is greater than or equal to 5, the function rounds the value up. The function contains two parameters: The first is the value or column name, and the second is the precision. Round Function also used to suppress decimal values. ROUND Function enables you to round a numeric value that is returned in a result set. Example of ROUND function to round one number up and another
Diksha Oracle Training Centre is a platform for IT Graduate as it provides both offline and online training to IT graduate to excel/his her carrier in IT industry.