MIMEHEADER_DECODE v14

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)