For oracle............. select to_char(156735,'999,99,999.') f

i want display a given number into Rupees Format

Like
Given number is : 156735

my Expected output is 1,56,735.

how to display?

Question Posted / amarendra kala

Answer Posted / amarendra kala

For oracle.............

select to_char(156735,'999,99,999.') from dual

output:- 1,56,735.

Is This Answer Correct ?

6 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do you declare an arraylist?

959

Is object an int c#?

883

Can we have two main methods in c#?

916

What does ienumerable mean?

870

What is data hiding in c#?

874

Is c# and c same?

855

what are the differences between a class and structure

1073

What is string in c# net?

883

Explain About delegates

992

How do I calculate relative time?

898

What is the difference between system.string and system.text.stringbuilder classes?

961

What is the default value of string in c#?

971

Can I use parseint?

852

Does a class need a constructor c#?

877

What is a deadlock lock?

896