25.67,-1
Trunc = 20
Round= 30
HOW????
Answers were Sorted based on User's Feedback
Answer / chandu
select trunc(25.67,-1),round(30) from dual;
TRUNC(25.67,-1) ROUND(30)
--------------- ----------
20 30
Is This Answer Correct ? | 3 Yes | 3 No |
Answer / 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 |
how to convert character strings to numeric values? : Sql dba
What are the usages of sql?
What do you mean by stored procedures?
What is sql prepared statement?
What is a mutating table
Fetch an entire row from the employees table for a specific employee ID:
what is the cursor and use of cursor in pl/sql ?
what are enums used for in mysql? : Sql dba
What is not null in sql?
Does sql require a server?
What is the difference between explicit and implicit cursors in oracle?
why use cursors?