What is the difference between ROUND and TRUNC function in SQL?

--Round function will increase the value by 1 if decimal value is greater than or equal to 5 else it will return same integer value without decimal.

--Truncate function will truncate the value and wont affect the integer part of value.