当前位置: 代码迷 >> Oracle管理 >> !这语句那里错了 ORACLE 语法不熟啊 T_T
  详细解决方案

!这语句那里错了 ORACLE 语法不熟啊 T_T

热度:85   发布时间:2016-04-24 06:00:39.0
求助!这语句那里错了 ORACLE 语法不熟啊 T_T
CREATE   OR   REPLACE   PROCEDURE   MC
(bds   in   varchar2)
as

  CURSOR   c1   IS   select   *   From   b$common_n   where   cd_bds=bds   and   g3e_fno <> 449;
begin
      FOR   c   IN   c1     LOOP
                if   c.g3e_fno=390   then  
                end   if;
      end   loop;
      commit;
end;
end   MC;

------解决方案--------------------
CREATE OR REPLACE PROCEDURE MC
(bds in varchar2)
as

CURSOR c1 IS select * From b$common_n where cd_bds=bds and g3e_fno <> 449;
begin
FOR c IN c1 LOOP
if c.g3e_fno=390 then
dbms_output.put_line( '? ');--干点什么
end if;
end loop;
commit;
end MC;
  相关解决方案