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 data dictionary in c#?

922

What is sorting in c#?

983

What are data types with examples?

962

What is the data provider name to connect to access database?

965

What is inner class in c#?

950

What is difference between web and window application?

832

What is difference between ilist and list?

885

Explain the difference between directcast and ctype.

978

What is parallel foreach in c#?

952

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

984

What are the concepts of dispose method?

915

Which function is the entry point for a DLL in MS Windows 3.1?

1154

What is the difference between ref and out in c#?

885

Does a loop recorder have to be removed?

1014

What is an escape sequence in c#?

957