答案:如果是java call一个存储过程的话 示例:
create or replace procedure proc_test
authid current_user
is
n number;
begin
select count(1) into n from dba_indexes where owner ='EIDNADM' and index_name ='INE_NO_INDEX' and table_name = 'NORESINTER';
if n=1 then
execute immediate 'drop table EIDNADM.INE_NO_INDEX';
end if;
end proc_test;
/
上一个:急!急!。。。oracle sql developer怎么打不开呢,出现enter the full pathname for java.exe
下一个:Oracle中查询相同部门、及同姓名的数据