Oracle Dual

Select round(13.19,1) from dual will return 13.2
Select round(13.19,-1) from dual ....what will be the output.....IN ORACLE

Questions by Sant_parkash   answers by Sant_parkash

Showing Answers 1 - 3 of 3 Answers

rajakumar_na

  • Nov 5th, 2007
 

Dual is a dummy table having one column dummy and one row with a value of X. Using this table we can get results from functions and calculations.

  Was this answer useful?  Yes

Imran_Javed

  • May 13th, 2008
 

SELECT ROUND(13.19,-1) FROM DUAL;
RETURN result IS 10;
 
WHEN you pass second argument AS "-1" , rounding takes place BEFORE the DECIMAL point.
That IS the reason IN the above example it rounds 13 TO 10. IF you USE 15 OR more than 15 it will ROUND TO 20

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions