SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to display $ Currency Symbol to Rs using Conversion Function ::: to_number

Ujjwal RanaSep 21 2016 — edited Sep 22 2016

I wonder if it is possible Currency Symbol from $ to Rs

Below is my table structure where SAL is in char type but i wanted to change is to TO_NUMBER which should display Rs. Currency symbol

| Name Null Type | |

---- ---- ------------

| SAL | VARCHAR2(20) |

This much i am able to make

SELECT SAL,to_number(sal,'$99999.00') from yy

But now instead of $ , I wanted to display as Rs like Rs.5000 , Rs.4000

Will appreciate if anyone could suggest the query for displaying SAL as Rs.5000 , Rs.4000 using TO_NUMBER conversion function

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 20 2016

Added on Sep 21 2016

15 comments

4,828 views