Reading this blog about interviewing for a software architect position got thinking that one of the most important taks of a software architect is to come up with right set of questions.
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
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' ...
Comments