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

Weblogic - Server Creation - Issues

Datasource creation using python script.  Python Script was failing after creating Datasource. From UI Admin Console, if I try to activat...