Oracle Magazine, May/June 2018
Database Developer PL SQL Watch it grow 2 Appending fullstop Watch it grow 3 Appending oracledatabase 18c Watch it grow 4 Appending yes you Watch it grow 5 andthen some can in fullstop oracledatabase 18c yes you Note that the items in the JSON array are not in the same order in which they appeared in the qualified expression that populated the associative array Thats due to the automatic ordering by character set when values are put into a string indexed collection REMOVE ELEMENTS FROM AN ARRAY When it comes to JSON arrays what PL SQL giveth PL SQL can also taketh away You can use the remove method to remove an element from an array at a specific location In the following block I remove any element from the array of strings if it cannot be converted to a number ORACLE MAGAZINE MAY JUNE 2018 70 DECLARE l_ nums json_ array_ t json_ array_ t 123 123456 abc 19e10 BEGIN FOR indx IN REVERSE 0 l_ nums get_ size 1
You must have JavaScript enabled to view digital editions.