Home » SQL & PL/SQL » SQL & PL/SQL » Hex Value to Base64 Value Convertion (SQL PL/SQL)
Hex Value to Base64 Value Convertion [message #685486] Mon, 24 January 2022 02:58 Go to next message
Khader Hussain
Messages: 3
Registered: January 2022
Junior Member
Hi All,

I am new in the Forum....Happy to see you all..

Hex Value :
010c426f6273205265636f726473020f3331303132323339333530303030330314323032322d30342d32355431353a33303a30305a0407313030302e3030050631353 02e3030

Base64 Value:
AQxCb2JzIFJlY29yZHMCDzMxMDEyMjM5MzUwMDAwMwMUMjAyMi0wNC0yNVQxNTozMDowMFoEBzEwMDAuMDAFBjE1MC4wMA==


I need urgent ...how i convert the value from Hex Format to Base64 Format..

Thanks a lot
Re: Hex Value to Base64 Value Convertion [message #685488 is a reply to message #685486] Mon, 24 January 2022 03:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68205
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Welcome to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Indent the code, use code tags and align the columns in result.

Also always post your Oracle version, with 4 decimals (query v$version), as often solution depends on it.

SQL> select utl_raw.cast_to_varchar2(
  2           utl_encode.base64_encode(
  3             hextoraw(
  4               '010c426f6273205265636f726473020f33313031323233393335303030303303143230'||
  5               '32322d30342d32355431353a33303a30305a0407313030302e303005063135302e3030'
  6             )
  7           )
  8         ) res
  9  from dual
 10  /
RES
--------------------------------------------------------------------------------------------------
AQxCb2JzIFJlY29yZHMCDzMxMDEyMjM5MzUwMDAwMwMUMjAyMi0wNC0yNVQxNToz
MDowMFoEBzEwMDAuMDAFBjE1MC4wMA==

1 row selected.
Re: Hex Value to Base64 Value Convertion [message #685490 is a reply to message #685488] Mon, 24 January 2022 03:30 Go to previous message
Khader Hussain
Messages: 3
Registered: January 2022
Junior Member
Really Great Reply Dear. Very Much Thanks to you Mr.Michel Cadot.This what i Need.
Previous Topic: Dynamically pass table name in PLSQL
Next Topic: ORA 00922 MISSING OR INVALID OPTION
Goto Forum:
  


Current Time: Tue Jun 28 16:59:01 CDT 2022