用pl/sql实现批量处理
set serveroutput on size 1000000 format wrapped
declare
cursor c is select 'alter user ' || lower(username) || ' identified by '||lower(username) md_pwd
3 from dba_users
where lower(username) in ('maps','readonly','ods_batch','mpsload','mapsuser')
order by username;
begin
for r in c loop
dbms_output.put_line(r.md_pwd);
execute immediate r.md_pwd;
end loop;
end;
/[@more@]
declare
cursor c is select 'alter user ' || lower(username) || ' identified by '||lower(username) md_pwd
3 from dba_users
where lower(username) in ('maps','readonly','ods_batch','mpsload','mapsuser')
order by username;
begin
for r in c loop
dbms_output.put_line(r.md_pwd);
execute immediate r.md_pwd;
end loop;
end;
/[@more@]
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/3345/viewspace-1031552/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- relink database
- DDL引起package失效后所碰到的错误-ora-04068
- 你想知道RMAN的恢复速度吗？
- RAC 安装后listener/tnsnames的load balance配置(TAF)
- 你想知道用RMAN备份时输出到磁带的写速度吗？
- windows平台下oracle快速诊断的一些方法：
- 不用NID改DB_NAME
- 纪念
- Getting ORA-01476 during execution of DBMS_STATS.GATHER_SCHEMA_STATS
- ORA-20000 While Executing dbms_stats.gather_schema_stats
