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 |
write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000
What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?
What are the types of variables use in pl sql?
What are analytic functions in sql?
What is a 'instead of trigger'?
what is sql? : Sql dba
Why do we use procedures?
what is a database transaction? : Sql dba
What is data abstraction in sql?
Is sql a backend language?
What are some predefined exceptions in pl/sql?
What is numeric function sql?