oracle不使用自带的DES工具包实现DES加解密

Oracle提供了DBMS_CRYPTO包可以用于加密和解密数据，包括DES算法。以下是一个使用DBMS_CRYPTO包进行DES加解密的例子：

1. 创建一个表用于存储加密后的数据

CREATE TABLE encrypted_data (
  id NUMBER(10) PRIMARY KEY,
  data_raw VARCHAR2(100),
  data_encrypted RAW(100)
);

2. 使用DBMS_CRYPTO包进行加密

DECLARE
  v_key RAW(8) := UTL_RAW.CAST_TO_RAW('my_key');
  v_data_raw VARCHAR2(100) := 'my_data';
  v_data_raw_raw RAW(100) := UTL_RAW.CAST_TO_RAW(v_data_raw);
  v_data_encrypted RAW(100);
BEGIN
  v_data_encrypted := DBMS_CRYPTO.ENCRYPT(
    src => v_data_raw_raw,
    typ => DBMS_CRYPTO.DES_CBC_PKCS5,
    key => v_key,
    iv => v_key
  );
  INSERT INTO encrypted_data (id, data_raw, data_encrypted)
  VALUES (1, v_data_raw, v_data_encrypted);
END;

3. 使用DBMS_CRYPTO包进行解密

DECLARE
  v_key RAW(8) := UTL_RAW.CAST_TO_RAW('my_key');
  v_data_encrypted RAW(100);
  v_data_raw_raw RAW(100);
  v_data_raw VARCHAR2(100);
BEGIN
  SELECT data_encrypted INTO v_data_encrypted FROM encrypted_data WHERE id = 1;
  v_data_raw_raw := DBMS_CRYPTO.DECRYPT(
    src => v_data_encrypted,
    typ => DBMS_CRYPTO.DES_CBC_PKCS5,
    key => v_key,
    iv => v_key
  );
  v_data_raw := UTL_RAW.CAST_TO_VARCHAR2(v_data_raw_raw);
  DBMS_OUTPUT.PUT_LINE(v_data_raw);
END;