OraFAQ Forum: SQL & PL/SQL » Two digit decimal

Home » SQL & PL/SQL » SQL & PL/SQL » Two digit decimal

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

Two digit decimal [message #677926]

Wed, 23 October 2019 20:09

Satya.tanmay
Messages: 3
Registered: April 2017

Junior Member

Requirement
Need result in 8digit,(comma not dot) then 2decimal digit i.e. 12345678,90 or 00001234,50 (if value is less than 8 digit then lpad with 0)

I am using query as
select LPAD(replace(to_number(to_char(1234.7,'S999999990D99')),'.',','),11,'0') from dual

I am getting result as : 000001234,7 but i need result as 000001234,70
i.e. 0 at the right is missing.

How can get result as 000001234,70 and what should be my query.

Report message to a moderator

[Message index]

		Two digit decimal By: Satya.tanmay on Wed, 23 October 2019 20:09
		Re: Two digit decimal By: BlackSwan on Wed, 23 October 2019 20:52
		Re: Two digit decimal By: Michel Cadot on Thu, 24 October 2019 00:23
		Re: Two digit decimal By: Satya.tanmay on Thu, 24 October 2019 07:53
		Re: Two digit decimal By: EdStevens on Thu, 24 October 2019 06:34
		Re: Two digit decimal By: EdStevens on Thu, 24 October 2019 07:01
		Re: Two digit decimal By: Solomon Yakobson on Thu, 24 October 2019 08:46

Previous Topic:	Exist Value in a table
Next Topic:	Cursor throwing error while passing to dbms_stats.gather_schema_stats

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 15:57:19 CDT 2024