Oracle Magazine, May/June 2019
Database Developer PL SQL ORACLE MAGAZINE MAY JUNE 2019 83 DBMS_ OUTPUT put_ line l_ ints indx END LOOP END 55 555 5555 And just as you can change the order of a records fields in the qualified expression when you use named notation you dont need to specify index values in order with an arrays qualified expression as you can see here DECLARE TYPE ints_ t IS TABLE OF INTEGER INDEX BY PLS_ INTEGER l_ ints ints_ t ints_ t 2 55 1 555 3 5555 BEGIN FOR indx IN 1 l_ ints COUNT LOOP DBMS_ OUTPUT put_ line l_ ints indx END LOOP END
You must have JavaScript enabled to view digital editions.