Answer Posted / gaurav
The TRUNC (n1, n2) function returns n1 truncated to n2 decimal places. If n2 is omitted, then n1 is truncated to 0 places. n2 can be negative to truncate (make zero) n2 digits left of the decimal point.
if you do it -2. answer will be zero in this case.
similar thing goes for round.It will become zero.
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What do you mean by field in sql?
What are the properties of a transaction?
How do you update a value in sql?
What is latest version of sql?
what are the nonstandard string types? : Sql dba
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
How many times can we commit in a loop?
What is the difference between nested table and varray?
Why cross join is used?
What are inbuilt functions in sql?
What does data normalization mean?
What is an inner join sql?
What is meant by truncate in sql?
How do I count records in sql?
What are the different types of sql commands?