How does the Oracle translate function work if the same character is in the 'from' and 'to' strings...
For example, I would suspect that translate('1a2b3c4d','1234','4321') would yield '4a3b2c1d' but I am not an Oracle guy and can't find any documentat...