First Blog

This is my first blog. I hope to be able to regularly post information on my areas of interset,
which are Java, J2EE, Oracle Database, Business Inteligence and Software Development

Comments

Post a Comment

Popular posts from this blog

Developer Productivity

The fact that some developers can be 10x more productive is not a myth. Very few organizations understand this and know how to hire and manage the best. The successfull organizations like Google, Microsoft and Oracle understand this and their success is partly based on this. 10x Developer Productivity
Read more

Oracle SQL JSON construct JSON Object

Your REST Client can consume JSON produced from a REST API. You can use Oracle SQL JSON functions to construct a JSON object and you can then use this to abstract out the source of the data. Your REST API client does not need to know that the data came from a set of tables. Here is an example of how to construct a JSON object. WITH t AS (     SELECT                                     JSON_OBJECT ( 'measureDetails' VALUE (                                         SELECT                                             JSON_ARRAYAGG(JSON_OBJECT('measureName' VALUE b.measure_name, 'classifications' VALUE JSON_ARRAYAGG(JSON_OBJECT('classification'         ...
Read more