advanced code snippet search

Posted By

geekzspot on 02/20/13


Tagged


Versions (?)

Oracle Loop through an Array

 / Published in: PL/SQL
 

Loop through a fixed list of values or strings

Expand | Embed | Plain Text 
  1. DECLARE
  2.     TYPE string_array IS TABLE OF VARCHAR(1);
  3.     rainbow_colors string_array := string_array('Red', 'Orange', 'Yellow', 'Green', 'Blue', 'Indigo', 'Violet');
  4. BEGIN
  5.     FOR i IN 1..rainbow_colors .COUNT LOOP
  6.        DBMS_OUTPUT.PUT_LINE(rainbow_colors (i));
  7.    END LOOP;
  8. END;

Report this snippet  

You need to login to post a comment.