declare str varchar2(500); begin str:='begin '; for i in 1..10 loop str:=str||'create table table'||i||'(a varchar2(10)); '; end loop; str:=str||' end;'; execute immediate str; end; / 注意grant create any table to user;
下载工具XML DB Query v2.0 简体中文版(SP1) http://www.greatengine.com/DownLoad/index.asp
Oracle 里用 commit,不用 go.
如:
SQL>create table tbl (a varchar(3));
SQL>commit; <- (提交的意思)在 Sql*plus 里执行脚本.
SQL>@C:\test.sql;但可以在不打开 sql*plus 的时候执行脚本.C:>sqlplus user1/pass1@Oradb @C:>test.sql;
http://211.99.196.144:8090/forum1/frontshow/dispbbs.jsp?boardid=109&id=4061
str varchar2(500);
begin
str:='begin ';
for i in 1..10 loop
str:=str||'create table table'||i||'(a varchar2(10)); ';
end loop;
str:=str||' end;';
execute immediate str;
end;
/
注意grant create any table to user;
http://www.greatengine.com/DownLoad/index.asp