Home » SQL & PL/SQL » SQL & PL/SQL » round (oracle,10g,windows xp)
round [message #425416] Fri, 09 October 2009 01:53 Go to next message
varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI
Senior Member

I have some nos range from 151 to 159 then.
i want to know the function name and how to round the value into 160.

thanks and regards

varosh
Re: round [message #425419 is a reply to message #425416] Fri, 09 October 2009 02:00 Go to previous messageGo to next message
_jum
Messages: 508
Registered: February 2008
Senior Member
Have a look at CEIL http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions017.htm#SQLRF00614
Re: round [message #425422 is a reply to message #425419] Fri, 09 October 2009 02:05 Go to previous messageGo to next message
varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI
Senior Member
the link cannot open in my system

if know the query, kindly send the query

thanks and regards

varosh
Re: round [message #425426 is a reply to message #425416] Fri, 09 October 2009 02:14 Go to previous messageGo to next message
sen_sam86
Messages: 33
Registered: August 2009
Location: Chennai
Member
SQL> SELECT ROUND(155, -1) FROM DUAL 
  2  /

ROUND(155,-1)
-------------
          160

SQL> SELECT ROUND(154,-1) FROM DUAL 
  2  /

ROUND(154,-1)
-------------
          150
Re: round [message #425429 is a reply to message #425426] Fri, 09 October 2009 02:19 Go to previous messageGo to next message
varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI
Senior Member
hi sam

thanks for your reply.
152,153,154 also rounded into 160


thanks and regards

varosh
Re: round [message #425431 is a reply to message #425429] Fri, 09 October 2009 02:21 Go to previous messageGo to next message
_jum
Messages: 508
Registered: February 2008
Senior Member
SELECT CEIL(151 / 10) * 10  FROM DUAL
Re: round [message #425433 is a reply to message #425431] Fri, 09 October 2009 02:26 Go to previous messageGo to next message
varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI
Senior Member
thanks sam

it works fine

thanks and regards

varosh
Re: round [message #425438 is a reply to message #425422] Fri, 09 October 2009 02:49 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
varosh81 wrote on Fri, 09 October 2009 09:05
the link cannot open in my system

if know the query, kindly send the query

thanks and regards

varosh

All documentation and especially SQL Reference can be found at http://tahiti.oracle.com.

Regards
Michel

Previous Topic: need in oracle
Next Topic: Cyrilic to Latin (merged)
Goto Forum:
  


Current Time: Sun Dec 04 12:39:30 CST 2016

Total time taken to generate the page: 0.09312 seconds