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 happens if null values are involved in expressions? : Sql dba
Is left join inner or outer by default?
What are the types of variable use in pl sql?
What is a join?
Explain clause in sql?
What is audit logout in sql profiler?
Why partition by is used in sql?
explain the options of myisamchk to improve the performance of a table. : Sql dba
What are aggregate functions in sql?
What is t sql in sql server?
what is the difference between myisam static and myisam dynamic? : Sql dba
How many disk partitions should I have?
What is pl sql record in oracle?
What is %rowtype in pl sql?
What is sqlexception in java?