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.

Expand|Select|Wrap|Line Numbers

  
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

Quote:

Originally Posted by 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.

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

Quote:

Originally Posted by Amit Parmar

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

Quote:

Originally Posted by Amit Parmar

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.

How to add $ sign to number data type?

re: How to add $ sign to number data type?

re: How to add $ sign to number data type?

re: How to add $ sign to number data type?

re: How to add $ sign to number data type?

re: How to add $ sign to number data type?

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about