1、创建MD5加密函数:
create or replace function MD5_Digest (
vin_string IN VARCHAR2
) RETURN VARCHAR2 IS
--
-- Return an MD5 hash of the input string.
--
BEGIN
RETURN UPPER(Dbms_Obfuscation_Toolkit.Md5 ( input => utl_raw.cast_to_raw(vin_string)
));
END MD5_Digest;
例子:更新所有用户的密码为加密后的888888
update user c set password=MD5_Digest(login_name||'888888')
2、重新生成序列的语句,重置开始值为表里的最大ID值
select 'drop sequence ' ||SEQUENCE_NAME||';'||CHR(10)||'create sequence ' || SEQUENCE_NAME || ' minvalue ' ||
MIN_VALUE || ' maxvalue ' || MAX_VALUE || ' start with ' ||
(LAST_NUMBER+2000) || ' increment by ' || INCREMENT_BY || ' cache ' ||
CACHE_SIZE || ';'
from USER_sequences
注:上面语句生成的是最大ID值+2000
create or replace function MD5_Digest (
vin_string IN VARCHAR2
) RETURN VARCHAR2 IS
--
-- Return an MD5 hash of the input string.
--
BEGIN
RETURN UPPER(Dbms_Obfuscation_Toolkit.Md5 ( input => utl_raw.cast_to_raw(vin_string)
));
END MD5_Digest;
例子:更新所有用户的密码为加密后的888888
update user c set password=MD5_Digest(login_name||'888888')
2、重新生成序列的语句,重置开始值为表里的最大ID值
select 'drop sequence ' ||SEQUENCE_NAME||';'||CHR(10)||'create sequence ' || SEQUENCE_NAME || ' minvalue ' ||
MIN_VALUE || ' maxvalue ' || MAX_VALUE || ' start with ' ||
(LAST_NUMBER+2000) || ' increment by ' || INCREMENT_BY || ' cache ' ||
CACHE_SIZE || ';'
from USER_sequences
注:上面语句生成的是最大ID值+2000