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

What is alias in c#?

898

What is stringbuilder c#?

903

Can we instantiate abstract class in c#?

843

What is the use of nullable types in c#?

932

What is an assembly in .net?

939

When a Static Constructor is called in a Class?

986

What is system console writeline in c#?

942

What is multithreading? What are the problems that comes with multithreading and how to manage them?

919

What's different between c# and c/c++?

887

Why we use delegates in c#?

853

What is escape character in c#?

861

Explain copy constructor?

1088

What is console write in c#?

878

If you define a user defined data type by using the struct keyword, is it a value type or reference type?

825

What is console used for?

944