Oracle Magazine, May/June 2019
Database Developer PL SQL TYPE species_ t IS TABLE OF species_ rt INDEX BY PLS_ INTEGER ORACLE MAGAZINE MAY JUNE 2019 88 l_ species species_ t species_ t 2 species_ rt Elephant Savannah 10000 1 species_ rt Dodos Mauritius 0 3 species_ rt Venus Flytrap North Carolina 250 BEGIN FOR indx IN 1 l_ species COUNT LOOP DBMS_ OUTPUT put_ line l_ species indx species_ name END LOOP END Dodos Elephant Venus Flytrap LESS AND MORE READABLE CODE PL SQL has always been an incredibly readable language It relies heavily on common English language keywords When you make use of all the modular features of PL SQL it is quite possible to produce a block of code that can almost literally be read like a book Certainly prior to Oracle Database 18c you could write and then read all those inline assignments You could also write your own custom functions one for each
You must have JavaScript enabled to view digital editions.