By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,473 Members | 1,274 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,473 IT Pros & Developers. It's quick & easy.

for round the partiular values in sql or oracle how it is possible

P: 5
which function is helpfull

when
102 divided by 100 gettig 1.2 ok ,after that i want display 2 from 1.2 in sql statement then what i should i do(like round up)
Nov 27 '13 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 1,043
use CEIL
Expand|Select|Wrap|Line Numbers
  1. select CEIL(1.2) from DUAL;
for an explanation read: https://forums.oracle.com/thread/2357732
Nov 27 '13 #2

P: 5
thanku for valueble time spend with us
Nov 30 '13 #3

Post your reply

Sign in to post your reply or Sign up for a free account.