---
title: "oracle有continue的用法"
author: "winzenghua"
date: "2009-07-10T14:07:00Z"
tags: []
slug: "oracle-continue"
draft: false
lastmod: "2009-07-10T14:07:00Z"
id: 987868
url: "https://java4gis.iteye.com/blog/987868"
---

oracle没有continue的用法，那么如何退出本次循环，而不退出整个循环呢？  
goto是一种方法吗，

create or replace procedure dd is  
i pls\_integer;  
begin  
i:=0;  
loop  
&lt;&lt;top&gt;&gt;

i:=i+1;  
if i&gt;10 then  
exit;  
end if;

if i&gt;5 then  
goto top;  
end if;

dbms\_output.put\_line(i);  
end loop;  
end;