帮忙看一条SQL,错在哪里?
set serveroutput on
declare li_count int;
ls_user varchar2(50);
begin
select user into ls_user from dual;
dbms_output.put_line (ls_user);
select count(*) into li_count from dba_tables where OWNER = ls_user and table_name = 'ABC';
dbms_output.put_line (li_count);
if li_count > 0 then
DROP TABLE ABC ;
end if;
end;
报告说 drop table abc ;的地方出错,谢谢!