How to add $ sign to number data type?

[Amit Parmar]

Hi Everybody,

I am fetching number data from a table. i want to add '$' sign to this data.
I already tried "TO_CHAR" function. This works fine but it converts number data type to string data type. I want it to be in number format only.
So, is there any way or any function that add '$' sign to number data without converting its data type?

Amit parmar

[debasisdas]

If you want to use string data it will be string only.

If retrieving only for display then try to concadinate the $ with the data.

[subashsavji]

YOU HAVE TO USE TO_CHAR FUNCTION.

 
SELECT TO_CHAR(SAL,'$99,999.00') FROM EMP;
declare
   v_num number;
begin
   v_num := to_number('$1234567.67','$9999999.99');
end;
 
 

[Amit Parmar]

If you want to use string data it will be string only.

If retrieving only for display then try to concadinate the $ with the data.

Hi Debasisdas,

Thanks for your reply,
As i said, i want it in number or money data type only. If i concatenate number with $ sign then the result would be in string data type that i don’t want.
If you know how to convert number data type to money data type then it would also helpful to me.

Amit Parmar

[amitpatel66]

Hi Debasisdas,

Thanks for your reply,
As i said, i want it in number or money data type only. If i concatenate number with $ sign then the result would be in string data type that i don’t want.
If you know how to convert number data type to money data type then it would also helpful to me.

Amit Parmar

Oracle does not provide any thing as MONEY DATA TYPE.

Check out post #3 of this thread on how to concateate "$" symbol before the salary or any amount column to be displayed as $000.00.

[debasisdas]

Hi Debasisdas,

Thanks for your reply,
As i said, i want it in number or money data type only. If i concatenate number with $ sign then the result would be in string data type that i don’t want.
If you know how to convert number data type to money data type then it would also helpful to me.

Amit Parmar

There is nothing like money datatype in oracle .
If you want to store pure numbers store in numbers else go for char type.