stang1
asked on
URL decode in Oracle
What's the best way to decode URL characters when pulling data from Oracle?
Can u give example like what is the input (URL) and which way you want to represent?
ASKER
the fields is varchar2(4000) and contains: (for example)
'Feb.+20%2C+2008%2C+Direct or+%28'
and my desired result:
'Feb. 20, 2008, Director ('
I'm just spooling to a .txt file and want to convert the encoded chars....
Thanks for your help....
'Feb.+20%2C+2008%2C+Direct
and my desired result:
'Feb. 20, 2008, Director ('
I'm just spooling to a .txt file and want to convert the encoded chars....
Thanks for your help....
ASKER
the field is varchar2(4000) and contains: (for example)
'Feb.+20%2C+2008%2C+Direct or+%28'
and my desired result:
'Feb. 20, 2008, Director ('
I'm just doing a select and 3 tbls and spooling to a .txt file and want to convert the encoded chars....
Thanks for your help....
'Feb.+20%2C+2008%2C+Direct
and my desired result:
'Feb. 20, 2008, Director ('
I'm just doing a select and 3 tbls and spooling to a .txt file and want to convert the encoded chars....
Thanks for your help....
Hi,
To my knowledge, oracle does not provide any functions for decoding URL.
However, you can use perl or java script for the same and call from oracle.
Hope it helps
To my knowledge, oracle does not provide any functions for decoding URL.
However, you can use perl or java script for the same and call from oracle.
Hope it helps
I'm afraid, not in version 9, but in version 11 (just in case anybody else is looking for somethink like this):
http://www.psoug.org/reference/utl_url.html
http://www.psoug.org/reference/utl_url.html
To my knowledge, the UTL_URL -package exists in Oracle 9 Release 2, however I'm not entirely certain of Release 1.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I just added a replace for the '+' and it worked really well. Thanks!