Oracle Magazine, May/June 2018
Database Developer PL SQL 25 Find the next defined index value remember strings The NEXT function returns NULL when going past the last index value and that will stop the WHILE LOOP ORACLE MAGAZINE MAY JUNE 2018 69 28 Finally return the JSON array Lets run this conversion function through its paces In the following block I take advantage of the new in Oracle Database 18c qualified expression feature enabling me to initialize the contents of a string indexed array with a single expression I then convert it to a JSON array and display the results all in a single call to DBMS_ OUTPUT put_ line DECLARE l_ array to_ json assoc_ array_ t to_ json assoc_ array_ t yes you can in oracledatabase 18c fullstop NULL and then some BEGIN DBMS_ OUTPUT put_ line to_ json to_ array l_ array to_ string END Here are the results Appending and then some Watch it grow 1 Appending can in
You must have JavaScript enabled to view digital editions.