Creating JSON document straight from SQL query – using LISTAGG and With Clause

Lucas Jellema June 14, 2011 Database, Databases, Oracle, PL/SQL, Web HTML5 CSS3 No Comments

This very brief article demonstrates how a fairly complex, nested JSON document can be created using a single SQL query. The main features used in the SQL statement are …

[Continue Reading...]

Producing simple Pie Chart straight out of the Oracle Database – leveraging dbms_epg, CANVAS, LISTAGG and some JavaScript

Lucas Jellema June 13, 2011 Database, Databases, Oracle, PL/SQL, Web HTML5 CSS3 No Comments

Once upon a time, I had something of a reputation for creating Charts in SQL. Bar Charts, Pie Charts, Gantt Charts and several other unlikely chart types, all created …

[Continue Reading...]

No JDBC based data retrieval in Java applications – RESTstyle, JSON formatted HTTP based interaction from Java to Database

Lucas Jellema January 30, 2011 Database, Java, Oracle, Oracle WebLogic Server 1 Comment

This article demonstrates how Java application can query data from relational databases (well, in this case more specifically the Oracle RDBMS) without the use of plain old JDBC but …

[Continue Reading...]

Tag: dbms_epg