OraFAQ Forum: SQL & PL/SQL » Hex Value to Base64 Value Convertion

Home » SQL & PL/SQL » SQL & PL/SQL » Hex Value to Base64 Value Convertion (SQL PL/SQL)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Hex Value to Base64 Value Convertion [message #685486]

Mon, 24 January 2022 02:58

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

Report message to a moderator

Re: Hex Value to Base64 Value Convertion [message #685488 is a reply to message #685486]

Mon, 24 January 2022 03:22

Michel Cadot
Messages: 68417
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.

Report message to a moderator

Re: Hex Value to Base64 Value Convertion [message #685490 is a reply to message #685488]

Mon, 24 January 2022 03:30

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.

Report message to a moderator

Previous Topic:	Dynamically pass table name in PLSQL
Next Topic:	ORA 00922 MISSING OR INVALID OPTION

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 23 07:15:46 CDT 2023