MIMEHEADER_DECODE v18

Use the MIMEHEADER_DECODE function to decode values that are encoded by the MIMEHEADER_ENCODE function. The signature is:

MIMEHEADER_DECODE(<buf> IN VARCHAR2)

This function returns a VARCHAR2 value.

Parameters

buf

buf contains the value encoded by MIMEHEADER_ENCODE to decode.

Examples

These examples use the MIMEHEADER_ENCODE and MIMEHEADER_DECODE functions to first encode and then decode a string:

edb=# SELECT UTL_ENCODE.MIMEHEADER_ENCODE('What is the date?') FROM DUAL;

      mimeheader_encode
------------------------------
 =?UTF8?Q?What is the date??=
(1 row)

edb=# SELECT UTL_ENCODE.MIMEHEADER_DECODE('=?UTF8?Q?What is the date??=')
FROM DUAL;

 mimeheader_decode
-------------------
 What is the date?
(1 row)