Dec
13

LOOP in PL/SQL

By admin  //  Oracle  //  View Comments

Syntax:

LOOP

statements

END LOOP;

Example:

DECLARE

cntr NUMBER :=0;

BEGIN

LOOP

cntr :=cntr +1;

IF cntr>100 THEN

Dbms_Output.put_line (cntr);

EXIT;

END IF;

END LOOP;

Related posts:

  1. Trigger in PL/SQL
  2. Procedure in PL/SQL
  3. Function in PL/SQL
  4. Writing SQL Statements
blog comments powered by Disqus

Namaste!

Hello! This is Nirmal Gyanwali, a freelance web developer from Kathmandu, Nepal. I am well versed with Open source CMS and portal frameworks like Joomla!, Wordpress, Drupal. If you're interested, you can contact me at info@nirmal.com.np.
Thanks!

Latest Tweets