TO_NUMBER function
Dan AFeb 10 2007 — edited Feb 12 2007I have been trying to figure this one out, I have read some of the documentation on the Oracle site, but still no joy.
I am not looking for the exact answer, just the way of doing a task like this:
To convert 'abcd' to $9999.
I see examples of "convert char to number" , but they all use "1234" as the example of the character to be changed.
I believe the answer to my problem may be a two staged one.
Thanks.
Message was edited by:
user556782