Oracle Magazine, May/June 2019
Database Developer PL SQL ORACLE MAGAZINE MAY JUNE 2019 87 BEGIN DBMS_ OUTPUT put_ line l_ stuff count WHILE l_ index IS NOT NULL LOOP DBMS_ OUTPUT put_ line l_ index l_ stuff l_ index l_ index l_ stuff NEXT l_ index END LOOP END 3 Family 5555 GRANDPA STEVEN 55 LoeyJuna 555 Finally theres nothing stopping you from using qualified expressions for arrays as well as records which comes in really handy when you have a collection of records DECLARE TYPE species_ rt IS RECORD species_ name VARCHAR2 100 habitat_ type VARCHAR2 100 surviving_ population INTEGER
You must have JavaScript enabled to view digital editions.