Convert string into a number
Hello everyone ^^
I would like to know if it was possible to convert a string into a sequence of numbers ONLY using mathematical functions? If it's the case, could you show me some examples?
For instance :
query : select operation('abc')
result : 010203 (it's not the real numbers, just an example)
I have tried conv(hex('string'),16,10) but it seems it causes an overflow with long strings, so it does not work properly ...
Another question, is there any way to divide a string only using mathematical functions?
Thanks in advance,
Geoffrey
Subject
Written By
Posted
Convert string into a number
October 17, 2010 03:36PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.