The scope of the index of a FOR LOOP. : For Loop « PL SQL « Oracle PL / SQL

Oracle PL / SQL 1.  Aggregate Functions 2.  Analytical Functions 3.  Char Functions 4.  Constraints 5.  Conversion Functions 6.  Cursor 7.  Data Type 8.  Date Timezone 9.  Hierarchical Query 10.  Index 11.  Insert Delete Update 12.  Large Objects 13.  Numeric Math Functions 14.  Object Oriented Database 15.  PL SQL 16.  Regular Expressions 17.  Report Column Page 18.  Result Set 19.  Select Query 20.  Sequence 21.  SQL Plus 22.  Stored Procedure Function 23.  Subquery 24.  System Packages 25.  System Tables Views 26.  Table 27.  Table Joins 28.  Trigger 29.  User Previliege 30.  View 31.  XML Java Java Tutorial Java Source Code / Java Documentation Java Open Source Jar File Download Java Articles Java Products Java by API C# / C Sharp C# / CSharp Tutorial ASP.Net JavaScript DHTML JavaScript Tutorial JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C Tutorial C++ C++ Tutorial PHP Python SQL Server / T-SQL Oracle PL/SQL Tutorial PostgreSQL SQL / MySQL MySQL Tutorial VB.Net VB.Net Tutorial Flash / Flex / ActionScript VBA / Excel / Access / Word Microsoft Office PowerPoint 2007 Tutorial Microsoft Office Excel 2007 Tutorial Microsoft Office Word 2007 Tutorial

Oracle PL / SQL » PL SQL » For Loop   The scope of the index of a FOR LOOP.   SQL> SQL> CREATE TABLE MyTable (   2    num_col    NUMBER,   3    char_col   VARCHAR2(60)   4    ); Table created. SQL> SQL> DECLARE   2    v_Counter  NUMBER := 7;   3  BEGIN   4    INSERT INTO MyTable (num_col)   5      VALUES (v_Counter);   6    FOR v_Counter IN 20..30 LOOP   7      INSERT INTO MyTable (num_col)   8        VALUES (v_Counter);   9    END LOOP;  10    INSERT INTO MyTable (num_col)  11      VALUES (v_Counter);  12  END;  13  / PL/SQL procedure successfully completed. SQL> SQL> drop table MyTable; Table dropped. SQL>   Related examples in the same category 1.  Your first FOR loop 2.  For loop: counter IN 1..5 3.  Nesting FOR loops 4.  REVERSE: Reversing the loop 5.  Changing the loop increment 6.  Use variable as an upper bound of for loop 7.  Exit(break) a for loop 8.  Call EXIT to exit a for loop 9.  Call EXIT WHEN to exit a function 10.  Put DBMS_OUTPUT.PUT_LINE in for loop 11.  If... End if 12.  A numeric FOR loop with insert statement 13.  Use for counter in insert statement 14.  FOR Loop Ranges with variable 15.  FOR Loop Scoping Rules 16.  Numeric FOR Loop

ww___w.___j_a_v___a__2s_._co___m_ | Contact Us

Copyright 2003 - 08 Demo Source and Support. All rights reserved.

All other trademarks are property of their respective owners.