Oracle Magazine, May/June 2019
Database Developer PL SQL ORACLE MAGAZINE MAY JUNE 2019 86 LOOP DBMS_ OUTPUT put_ line l_ index l_ stuff l_ index l_ index l_ stuff NEXT l_ index END LOOP END 3 Juna 5555 Loey 555 Steven 55 Furthermore those index values do not need to be literals They can be expressions they simply must resolve explicitly or implicitly to the correct type integer or string DECLARE TYPE by_ string_ t IS TABLE OF INTEGER INDEX BY VARCHAR2 100 l_ stuff by_ string_ t by_ string_ t UPPER Grandpa Steven 55 Loey Juna 555 SUBSTR Happy Family 7 5555 l_ index varchar2 100 l_ stuff first
You must have JavaScript enabled to view digital editions.