Home » SQL & PL/SQL » SQL & PL/SQL » Upper Value
Upper Value [message #23139] Tue, 19 November 2002 15:49 Go to next message
Rizwan Qazi
Messages: 135
Registered: August 2002
Senior Member
Is there any Oracle function, say FUNCX, which which allows me to return the upper value of a decimal number

e.g. SELECT FUNCX(7.1) FROM DUAL

returns

8

Thanks

Rizwan

Report message to a moderator

Re: Upper Value [message #23140 is a reply to message #23139] Tue, 19 November 2002 16:31 Go to previous message
Amit Chauhan
Messages: 74
Registered: July 1999
Member
 
select ceil (7.1) from dual
/
8


Hope that helps
Thanks
Amit

Report message to a moderator

Previous Topic: Reading a File using UTL_FILE
Next Topic: Operator usage - help
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 29 05:42:43 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.