我把您的语句copy到toda的sql editor窗口 然后选择 Execute statement 出现 ORA-06550: line 4, column 33: PLS-00201: identifier 'A1' must be declared ORA-06550: line 4, column 5: PL/SQL: SQL Statement ignored是不是pl/sql应该用run as script????请指教!
Run Script 出下面的错误! Error on line 0 declare n number; begin select count(*) into n from a1; end;ORA-06550: line 4, column 33: PLS-00201: identifier 'A1' must be declared ORA-06550: line 4, column 5: PL/SQL: SQL Statement ignored
然后选择
Execute statement
出现
ORA-06550: line 4, column 33:
PLS-00201: identifier 'A1' must be declared
ORA-06550: line 4, column 5:
PL/SQL: SQL Statement ignored是不是pl/sql应该用run as script????请指教!
Error on line 0
declare
n number;
begin
select count(*) into n from a1;
end;ORA-06550: line 4, column 33:
PLS-00201: identifier 'A1' must be declared
ORA-06550: line 4, column 5:
PL/SQL: SQL Statement ignored
select * from a1
看看 有没有错?
我在sqlplus
中
用 select * from my.a1
my是一个schema
可以出来结果
!!!!!!!