如何用脚本删除用户表

[EnjoySun]

我的目的是在删除以前创建的表
delare
tbl_name varchar2(256);
cursor drop_cs
is
select table_name from user_table where table_name like 'gn_%';
begin
open drop_cs;
while drop_cs%found
loop
fetch drop_cs into tbl_name;
drop table tbl_name;
end loop;
end;
/

但是这个脚本不能工作，
请问各位大侠帮帮我啊

[welyngj]

delare
tbl_name varchar2(256);
cursor drop_cs
is
select table_name from user_table where table_name like 'gn_%';
begin
open drop_cs;
while drop_cs%found
loop
fetch drop_cs into tbl_name;
execute immediate 'drop table '||tbl_name;
end loop;
end;
/

[zhaokeke2004]

up,
要用动态的PL/SQL:execute immediate 'drop table '||tbl_name;

[dybinchn]

学习

[lvjack]

select table_name from user_table where table_name like 'gn_%';
一行也有问题
oracle表名一般都是大写的，这一行查不到数据的

应改为select table_name from user_table where table_name like 'GN_%';