Breaking News: Grepper is joining You.com. Read the official announcement!

How to access and loop and array in PLSQL

Marcel Tauber answered on May 17, 2023 Popularity 2/10 Helpfulness 1/10

answer How to access and loop and array in PLSQL

How to access and loop and array in PLSQL

Comment

FOR index IN arr.FIRST .. arr.LAST
LOOP
arr(index)
END LOOP;

DECLARE
    SUBTYPE country_ty IS VARCHAR2(50);
    TYPE countries_varr_ty IS VARRAY(10) OF country_ty;
    l_varr_countries countries_varr_ty :=
        countries_varr_ty
        (
            'Iran', 'France', 'United Kingdom', 'United States', 'Germany',
            'Spain', 'Canada', 'Australia', 'South Africa', 'Afganistan'
        );
    l_country country_ty;
BEGIN
    FOR counter IN l_varr_countries.FIRST .. l_varr_countries.LAST
    LOOP
        l_country := l_varr_countries(counter);
        DBMS_OUTPUT.PUT_LINE('The current value in the array is: ' 
            || l_country);
    END LOOP;
END;
/

For In Loop

Popularity 2/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: plsql sql

Link to this answer
Share Copy Link