Oracle中判断表是否存在!
declare v_cnt Number;
begin
select count(*) into v_cnt from user_tables where table_name = 'YOURTABLENAME';
if v_cnt>0 then
dbms_output.put_line('该表存在!');
else
dbms_output.put_line('该表不存在或当前用户无权访问!');
end If;
End;
begin
select count(*) into v_cnt from user_tables where table_name = 'YOURTABLENAME';
if v_cnt>0 then
dbms_output.put_line('该表存在!');
else
dbms_output.put_line('该表不存在或当前用户无权访问!');
end If;
End;