What is FOR…LOOP?

May 13th, 2005 by uCertify Leave a reply »

FOR…LOOP is an iterative control. It is used when iterations need to occur a fixed number of times.

Syntax:

FOR counter IN [REVERSE] start_range.. end_range LOOP
    Statements;
END LOOP;

By default, iteration proceeds upward from the start range to the end range. But if the keyword REVERSE is used, iteration proceeds downward from the end range to the start range.

Note: The range is part of an iteration scheme, which is enclosed by the keywords FOR and LOOP. A double dot (..) serves as the range operator.
Click here to get free oracle-pl-sql Oracle PL/SQL Developer exam practice questions. Best exam simulation Oracle 1Z0-001 download free trial.
Like this article? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
  • Share/Bookmark
Advertisement

Leave a Reply

uCertify.com | Our Company | Articles | Contact Us | News and Press Release | uCertify India | Entries (RSS)
MCSE: MCSA, MCTS, MCITP    JAVA Certification: SCJP, SCWCD    Cisco Certification: CCNA, CCENT    A+, Network+, Security+ Project+
Oracle Certification: OCP 11g, OCP 10g, OCA 11g, OCA 10g    CIW foundation    EC-212-32,    CISSP    Photoshop ACE CS4    Adobe Flash ACE, PMP, CAPM
© 2008 uCertify.com. All rights reserved. All trademarks are the property of their respective owners.