持续更新中。。。
---修改用户密码
alter user 用户名 identified by 新密码;
---修改用户密码永不过期策略,修改数据库的策略,所有用户密码服从此策略
alter profile default limit password_life_time unlimited;
select * from dba_profiles s where s.profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME'; ---查询策略
---解锁用户
alter user 用户名 account unlock;
---设置用户密码无限制尝试,不锁定策略
ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;
---删除用户及表空间
drop user test cascade;
DROP TABLESPACE BBSP INCLUDING CONTENTS AND DATAFILES;
--强制断开用户连接
select username, sid, serial# from v$session where username='TEST';
Alter system kill session'142,54205';
--截取字符串+补全字符串+拼接字符串
select concat(substr('100007',instr('100007','100',-1)+2),lpad(2,'4','0')) from dual;