Oracle - Oracle Dual

GeekInterview.com > Tech FAQs > Oracle

Go To First | Previous Question | Next Question

Oracle | Question 159 of 224

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

Total Answers and Comments: 3

Last Update: May 13, 2008 Asked by: Sant_parkash

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

November 05, 2007 22:54:12

rajakumar_na

RE: Oracle Dual

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.

Is this answer useful? Yes | No

November 20, 2007 20:38:52

xuqinglei2000

Member Since: June 2007 Contribution: 3

RE: Oracle Dual

SELECT ROUND(13.19,-1) FROM DUAL
RETURN RESULT IS 10;

Is this answer useful? Yes | No

May 13, 2008 05:07:39

Imran_Javed

Member Since: May 2008 Contribution: 23

RE: Oracle Dual

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

Is this answer useful? Yes | No

Go To Top