Difference between revisions of "SQL - Encode/decode function (base64)"
Jump to navigation
Jump to search
(Created page with "<code> set define off; </code> - Encode<br/> <code>SELECT UTL_RAW.cast_to_varchar2(</code><br/> <code>UTL_ENCODE.base64_encode(</code><br/> <code>UTL_...") |
|||
| Line 11: | Line 11: | ||
- Decode<br/> | - Decode<br/> | ||
<code>SELECT UTL_RAW.cast_to_varchar2(/code><br/> | <code>SELECT UTL_RAW.cast_to_varchar2(</code><br/> | ||
<code>UTL_encode.base64_decode(</code><br/> | <code>UTL_encode.base64_decode(</code><br/> | ||
<code>UTL_RAW.cast_to_raw('U3VyZiB0aGUgd29ybGQsIGxvdmUgdGhlIHdvbWVuLCBlYXQgYXMgbXVjaCBhcyB1IGNhbi4uLiB4byB4byBULg=='))) "42"</code><br/> | <code>UTL_RAW.cast_to_raw('U3VyZiB0aGUgd29ybGQsIGxvdmUgdGhlIHdvbWVuLCBlYXQgYXMgbXVjaCBhcyB1IGNhbi4uLiB4byB4byBULg=='))) "42"</code><br/> | ||
<code>FROM dual;</code> | <code>FROM dual;</code> | ||
Revision as of 13:59, 23 August 2016
set define off;
- Encode
SELECT UTL_RAW.cast_to_varchar2(
UTL_ENCODE.base64_encode(
UTL_RAW.cast_to_raw('Surf the world, travel & eat as much as u can... xo xo T.')))
FROM dual;
- Decode
SELECT UTL_RAW.cast_to_varchar2(
UTL_encode.base64_decode(
UTL_RAW.cast_to_raw('U3VyZiB0aGUgd29ybGQsIGxvdmUgdGhlIHdvbWVuLCBlYXQgYXMgbXVjaCBhcyB1IGNhbi4uLiB4byB4byBULg=='))) "42"
FROM dual;