create 1000 users in oracle quickly
来源:互联网 发布:java classpath级别 编辑:程序博客网 时间:2024/05/22 03:30
SQL> create or replace procedure create_user
2 is
3 i integer:=0;
4 begin
5 for i in 1..1000 loop
6 execute immediate 'create user test00a'||i||' identified by '||'test00'||'12345 default tablespace users temporary tablespace temp account unlock';
7 end loop;
8 end ;
9 /
Procedure created.
SQL> exec create_user;
PL/SQL procedure successfully completed.
SQL> select count(*) from dba_users;
COUNT(*)
----------
2029
- create 1000 users in oracle quickly
- SwitchNetConfig - Laptop users, quickly switch network and proxy configuration in different places
- Create tablespace in Oracle
- Users, roles and privileges in Oracle
- Users and Responsibilites in Oracle EBS
- Users and Responsibilites in Oracle EBS
- draw quickly in wpf
- create users and grant privilages
- How to create Function/Procedure in Oracle?
- Using Create directory & UTL_FILE in Oracle
- Using Create directory & UTL_FILE in Oracle
- Using Create directory & UTL_FILE in Oracle
- open hosts file quickly in windows
- Quickly fill blank cells in Excel
- A good introduction for RCP and Create it quickly
- Create Pro Sales Pages Quickly W/o Photoshop!
- MySQL create users and grant privilege
- Users and Groups in Linux
- 集成电路的检测经验介绍
- 软件测试工作日记(连载)
- ubuntu 10.4 下安装oracle客户端
- JNI 下的文件操作
- javascript中的日期和星期[收藏]
- create 1000 users in oracle quickly
- 转载一篇 GZipStream用法
- 国庆长假出游最实用的5款智能手机软件
- JUnit Cookbook
- asp.net 导出excel
- 每天一剂Rails良药 - 目录概览
- 如何安装flash debugger in ubuntu
- firefox与ie相同属性集结中
- 努力做一个内心强大的女子