PL/SQL-JSON implements encoding and decoding JSON in a PL/SQL environment. Using the objects json_object and json_array allows to compose and parse JSON. A performance test is avilable in the ...
sum(decode(extract(year from hire_date),2005, 1, 0)) "2005", sum(decode(extract(year from hire_date),2006, 1, 0)) "2006", sum(decode(extract(year from hire_date),2007 ...