Amazon

Saturday, May 29, 2010

Oracle - Using Lables

<<main>>
DECLARE
ctr constant INTEGER := 11;
BEGIN
FOR ctr IN 1..25 LOOP -- ctr is declared locally in FOR loop
IF main.ctr > 10 THEN -- Using main label it refers to global variable
dbms_output.put_line('hello');
END IF;
END LOOP;
END main;

No comments:

Post a Comment

Amazon Best Sellors

TOGAF 9.2 - STUDY [ The Open Group Architecture Framework ] - Chap 01 - Introduction

100 Feet View of TOGAF  What is Enterprise? Collection of Organization that has common set of Goals. Enterprise has People - organized by co...