Oracle自定义DES3加解密
之前有部分数据是在java服务端中进行des3加密,后需要在oracle中直接进行解密,记录以供参考:select fun_encrypt_app('123','9OOuLGtKQNkgkhm8MS/mbopUlPQ7vwtD') from dual;select fun_decrypt_app('f3……
02-22 立刻查看
oracle插入主键与显示id不一致
SELECT xshtest.XSHE_PRODUCT_CFG_SEQ.nextval as id from DUAL这里查出序列为1102606,然后insert到库中insert into xshtest.XSHE_PRODUCT_CFG (id,product_id,cateid) VALUES (1102606,'313132221……
09-15 立刻查看