欢迎投稿

今日深度:

oracle存储过程loop循环,

oracle存储过程loop循环,


oracle的循环:

declare vcount integer default 0;

begin 
  <<loop_label>>
  LOOP
   vcount:=vcount+1;
   if vcount > 5 then exit;
   end if;
   insert into student values(vcount+5,'Tom');
   end LOOP loop_label;

end ;

Teradata的循环:


www.htsjk.Com true http://www.htsjk.com/teradata/36790.html NewsArticle oracle存储过程loop循环, oracle的循环: declare vcount integer default 0; begin    loop_label   LOOP    vcount:=vcount+1;    if vcount 5 then exit;    end if;    insert into student values(vcount+5,'Tom');    end LOO...
相关文章
    暂无相关文章
评论暂时关闭