Oracle Magazine, May/June 2018
Database Developer PL SQL ORACLE MAGAZINE MAY JUNE 2018 64 true 123 name steven HOW BIG IS MY ARRAY The JSON_ ARRAY_ T object type offers a get_ size method that returns the number of elements in the array This method can iterate through all the elements of an array In the following block I get the number of elements in the array and then use a loop to determine how many elements are in each array within that array DECLARE l_ stuff json_ array_ t BEGIN l_ stuff json_ array_ t Stirfry Yogurt Apple carpet rug tiles dirt concrete smile frown grimace puzzled DBMS_ OUTPUT put_ line Number of elements in array l_ stuff get_ size FOR indx IN 0 l_ stuff get_ size 1 LOOP
You must have JavaScript enabled to view digital editions.