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 the system namespace?

922

What are the different types of classes?

1011

What is virtual in c#?

897

How do you use nullable?

968

How to find Percentage, name ,College from a resume or document ? How to export these values to other page in C#?

934

What are the examples of data types?

996

What is the best dependency injection c#?

893

What type of data type conversion happens when the compiler encounters the following code?

946

What is a multicast delegate in c#?

999

Describe an abstract class?

1001

What is xpath in c#?

980

What is scope c#?

888

What is the use of main method in c#?

993

What is ilist c#?

958

Explain the difference between directcast and ctype.

1015