Hi All i wanted to use the below code as LOV in Apex 4.2.
DECLARE
TYPE MY_TAB IS TABLE OF VARCHAR2(20) INDEX BY VARCHAR2(1);
VAR1 MY_TAB;
X VARCHAR2(1);
BEGIN
VAR1('A') := 'APPLE';
VAR1('B') := 'BOY';
VAR1('C') := 'CAT';
VAR1('D') := 'DOG';
VAR1('E') := 'ELEPHANT';
X := 'A';
LOOP
DBMS_OUTPUT.PUT_LINE (X||' for '||VAR1(X));
X := VAR1.NEXT(X);
EXIT WHEN X IS NULL;
END LOOP;
END;
how to use the same, could some one please help??
Thanks,
Ranjeet