MIMEHEADER_DECODE v13
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)
that will be decoded.
Examples
The following 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)