OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » round (oracle,10g,windows xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

round [message #425416]

Fri, 09 October 2009 01:53

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

Report message to a moderator

Re: round [message #425419 is a reply to message #425416]

Fri, 09 October 2009 02:00

_jum
Messages: 577
Registered: February 2008

Senior Member

Have a look at CEIL http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions017.htm#SQLRF00614

Report message to a moderator

Re: round [message #425422 is a reply to message #425419]

Fri, 09 October 2009 02:05

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

Report message to a moderator

Re: round [message #425426 is a reply to message #425416]

Fri, 09 October 2009 02:14

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

Report message to a moderator

Re: round [message #425429 is a reply to message #425426]

Fri, 09 October 2009 02:19

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

Report message to a moderator

Re: round [message #425431 is a reply to message #425429]

Fri, 09 October 2009 02:21

_jum
Messages: 577
Registered: February 2008

Senior Member

SELECT CEIL(151 / 10) * 10  FROM DUAL

Report message to a moderator

Re: round [message #425433 is a reply to message #425431]

Fri, 09 October 2009 02:26

varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI

Senior Member

thanks sam

it works fine

thanks and regards

varosh

Report message to a moderator

Re: round [message #425438 is a reply to message #425422]

Fri, 09 October 2009 02:49

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 10 16:12:34 CDT 2025