The TEXT_DECODE function is used to decode a string encoded by TEXT_ENCODE and return the decoded string.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support it.
Syntax
UTL_ENCODE.TEXT_DECODE (
buf IN VARCHAR2 CHARACTER SET ANY_CS,
encode_charset IN VARCHAR2 DEFAULT NULL,
encoding IN PLS_INTEGER DEFAULT NULL)
RETURN VARCHAR2;
Parameters
Parameter |
Explanation |
|---|---|
| buf | The string to be decoded. |
| encode_charset | The character set used for encoding. Default value:NULL, which indicates to use the default character set of the database. |
| encoding | Encoding method. Valid values:1(Base64) or2(Quoted-printable). The default value isNULL, which indicates that the data should be decoded in quoted-printable format. |
Return value
Return Value |
Description |
|---|---|
| VARCHAR2 | The decoded string, represented in the database character set. |