请问各位大神 这个错在哪里?
5/1 PL/SQL: SQL Statement ignored
5/36 PL/SQL: ORA-00942: 表或视图不存在
create or replace procedure jianbiao(biaoming in varchar)
is
shuliang number;
begin
select count(*) into shuliang from user_table
where table_name=biaoming;
if
shuliang>0
then
execute immediate 'truncate table biaoming';
dbms_output.put_line('该表存在,已清空该表');
else
execute immediate 'create table biaoming';
dbms_output.put_line('已创建该表');
end if;
end;