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 are analytic functions in sql?
What is query execution plan in sql?
What is sql partition?
What is substitution variable?
Which join is like an inner join?
Who developed sql?
Can we use pl sql in sql server?
Why trigger is used in sql?
what is csv? : Sql dba
How many sql core licenses do I need?
What are dml commands?
What is the benefit of foreign key?
What are pl sql data types?
What are the different types of triggers?
What is nvl?