25.67,-1
Trunc = 20
Round= 30

HOW????

Answers were Sorted based on User's Feedback



25.67,-1 Trunc = 20 Round= 30 HOW????..

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

25.67,-1 Trunc = 20 Round= 30 HOW????..

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

Post New Answer

More SQL PLSQL Interview Questions

how to convert character strings to numeric values? : Sql dba

0 Answers  


What are the usages of sql?

0 Answers  


What do you mean by stored procedures?

0 Answers  


What is sql prepared statement?

0 Answers  


What is a mutating table

5 Answers   TCS, Tech Mahindra,






Fetch an entire row from the employees table for a specific employee ID:

2 Answers  


what is the cursor and use of cursor in pl/sql ?

4 Answers  


what are enums used for in mysql? : Sql dba

0 Answers  


What is not null in sql?

0 Answers  


Does sql require a server?

0 Answers  


What is the difference between explicit and implicit cursors in oracle?

0 Answers  


why use cursors?

5 Answers   Oracle,


Categories