这个脚本怎么有错呢? EXECUTE IMMEDIATE ('drop SEQUENCE '||v_objname); 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 EXECUTE IMMEDIATE ('drop SEQUENCE '||lower(v_objname)); SQL> declare 2 v_objtype varchar(20); 3 v_objname varchar(40); 4 i integer; 5 cursor cur_allobjects is 6 select object_type, object_name from all_objects where owner='CBI'; 7 begin 8 open cur_allobjects; 9 10 Loop 11 fetch cur_allobjects into v_objtype, v_objname; 12 Exit When cur_allobjects%NotFound; 13 14 if v_objtype='SEQUENCE' and lower(v_objname)='da' then 15 EXECUTE IMMEDIATE ('drop SEQUENCE '||v_objname); 16 end if; 17 end loop; 18 19 close cur_allobjects; 20 end; 21 /PL/SQL procedure successfully completed 发现是登陆的用户不对, 我刚刚是用sys用户登陆的. 现在用CBI登陆编译就正常了. 但是发现游标打开是用的. 而select object_type, object_name from all_objects where owner='CBI'; 执行是有数据的 sorry, 写错了. "标打开是用的"----游标打开是空的. 再帮我看看这个问题http://community.csdn.net/Expert/topic/4651/4651930.xml?temp=.2220728谢谢 将文本文件导入到Oracle的问题 oracle创建用户的问题 求救:一个字段值当为条件的一对多表查询的SQL写法 强烈建议:oracle的各位爱好者把自己知道的一些学习资源共享出来吧!!!!! oracle 8.1.6 for NT 的安装问题 如何查 如何用sql查询出某个月的第一天,和最后一天 这个触发器该怎么写? 急!!!!请问在ora8中,表名、字段名及字段类型是存在哪些系统表内的????? 高手看我的存储过程哪儿不对 在线等 如何在URL中添入信息实现以sysdba方式连接oracle 如何分月求合?
2 v_objtype varchar(20);
3 v_objname varchar(40);
4 i integer;
5 cursor cur_allobjects is
6 select object_type, object_name from all_objects where owner='CBI';
7 begin
8 open cur_allobjects;
9
10 Loop
11 fetch cur_allobjects into v_objtype, v_objname;
12 Exit When cur_allobjects%NotFound;
13
14 if v_objtype='SEQUENCE' and lower(v_objname)='da' then
15 EXECUTE IMMEDIATE ('drop SEQUENCE '||v_objname);
16 end if;
17 end loop;
18
19 close cur_allobjects;
20 end;
21 /PL/SQL procedure successfully completed
http://community.csdn.net/Expert/topic/4651/4651930.xml?temp=.2220728
谢谢