Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.news2me.com!news.glorb.com!postnews.google.com!i3g2000cwc.googlegroups.com!not-for-mail
From: happyardy@gmail.com
Newsgroups: comp.databases.oracle.misc
Subject: what is the SQL equivalent of 'continue' and 'break' in C ?
Date: 8 Aug 2006 06:50:30 -0700
Organization: http://groups.google.com
Lines: 21
Message-ID: <1155045030.708842.232460@i3g2000cwc.googlegroups.com>
NNTP-Posting-Host: 134.153.234.91
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1155045036 4855 127.0.0.1 (8 Aug 2006 13:50:36 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 8 Aug 2006 13:50:36 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; InfoPath.1),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: i3g2000cwc.googlegroups.com; posting-host=134.153.234.91;
   posting-account=csOOww0AAABRnfj8LynXGF0hR3mfOsV1
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:129131

what is the SQL equivalent of 'continue' and 'break' in C ?

like can I do this...


for counter in 1..10
  if(something something)
   ( if (something)
     ( if(something)
 then continue;

   //Rest of the for loop

 end loop;

Would it start the next iteration without processing the rest of the
loop ?

thanks
 - Ardy