Oracle Magazine, May/June 2018
Database Developer PL SQL ORACLE MAGAZINE MAY JUNE 2018 73 l_ object json_ object_ t l_ keys json_ key_ list l_ element json_ element_ t BEGIN l_ array json_ array_ t parse json_ document_ in put_ line Traverse l_ array stringify level_ in FOR indx IN 0 l_ array get_ size 1 LOOP put_ line Index indx level_ in CASE WHEN l_ array get indx is_ string THEN EXECUTE IMMEDIATE leaf_ action_ in USING l_ array get_ string indx level_ in WHEN l_ array get indx is_ object THEN l_ object TREAT l_ array get indx AS json_ object_ t l_ keys l_ object get_ keys FOR k_ index IN 1 l_ keys COUNT LOOP EXECUTE IMMEDIATE leaf_ action_ in 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
You must have JavaScript enabled to view digital editions.