Home » SQL & PL/SQL » SQL & PL/SQL » SQL question - simple
SQL question - simple [message #38168] Wed, 27 March 2002 02:36 Go to next message
Nikolas Dinno
Messages: 1
Registered: March 2002
Junior Member
I have the number e.g. 63,9823874012983
and I want to round it to 63,98 and at the same time
change the , to a .

Any ideas how to do that? I am stuck for some hours now, even though I know it is a combination of "round" and "lpad"

Thanks

Report message to a moderator

Re: SQL question - simple [message #38169 is a reply to message #38168] Wed, 27 March 2002 04:49 Go to previous message
Paulo Gonzaga
Messages: 1
Registered: March 2002
Junior Member
Will this this work for you? It's a combination of "replace" and "round".

select round(replace('63,9823874012983',',','.'),2)
from dual;

Report message to a moderator

Previous Topic: regarding file access in pl/sql procedure
Next Topic: oracle query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 06:23:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.