CREATE OR REPLACE PROCEDURE JACKY_MY_PROCEDURE
is
begin
SELECT COUNT(1) FROM BOILER WHERE SYDWDM IN (SELECT DSDM FROM DZ WHERE DSDM='440102');
end JACKY_MY_PROCEDURE;
is
begin
SELECT COUNT(1) FROM BOILER WHERE SYDWDM IN (SELECT DSDM FROM DZ WHERE DSDM='440102');
end JACKY_MY_PROCEDURE;
is
n number;
begin
SELECT COUNT(1) into n FROM BOILER WHERE SYDWDM IN (SELECT DSDM FROM DZ WHERE DSDM='440102');
end;
/
is
N integer;
begin
SELECT COUNT(column_name/*) into N
FROM BOILER
WHERE SYDWDM IN (SELECT DSDM FROM DZ WHERE DSDM='440102');
end;
is
begin
SELECT COUNT(1) into p_num FROM BOILER WHERE SYDWDM IN (SELECT DSDM FROM DZ WHERE DSDM='440102');
end;
/
declare
num number;
begin
MY_PROCEDURE(num);
dbms_output.put_line(num);
end;
/
我先安装oracle,再强制删除;再重装时就老检查到以前建立的数据库(已删除),这是为何?
再说你的存储过程创建就会报错无效吧,拿到ql plus里去create or replace然后show err~