#CRYPT_ASYM_DECRYPT

CRYPT_ASYM_DECRYPT
CRYPT_ASYM_DECRYPT ( expr1 , expr2 )

CRYPT_ASYM_DECRYPT函数以expr2为私钥对expr1进行解密,返回解密结果。

本函数遵循如下规则:

  • expr1/expr2只支持VARCHAR/CHAR类型。

  • 当expr1为null时返回null。

示例

SELECT CRYPT_ASYM_DECRYPT('30700220017ABB676F3F36634034D803E89F9154D759C8FED9F610E2C4AD4CD732B8E68F02202BBA7E237F742822BE52DF1C023E0BD73A90CA3FFE8F7E96FA35DCDC1D04BA3B042047C6CC48695184FAC7555101346CB3F5422884B67F7358763D83BD664E31FCED0408D312303A375D0CBF', '69179AA2962473D20BFDC34652E52F145AD03A14CFB026CAB9B2C29127E488BA') FROM dual;

CRYPT_ASYM_DECRYPT(' 
-------------------- 
symEncry            

pdf-btn 下载文档
copy-btn 复制链接