Browsing articles tagged with " loop"
Dec
13

GOTO statement in PL/SQL

By admin  //  Oracle  //  View Comments

Example:

IF result= ‘fail’

THEN

GOTO fail_msg

END IF;

<<fail_msg>>

Message (“Student is Failed’);

Dec
13

While Loop in PL/SQL

By admin  //  Oracle  //  View Comments

Syntax:

WHILE < Condition  true> LOOP

<Statement>

END LOOP;

Example:

DECLARE

cnt NUMBER:=0;

BEGIN

WHILE cnt<=10 LOOP

cnt:=cnt+1;

Message (‘While loop executes);

END LOOP;

END;

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!

Recent Posts

Tags

Latest Tweets