Good tutorial on Oracle SQL Model

The Oracle SQL Model allows you to do a lot more things in SQL that you would normally have done in PL/SQL. You can find a good tutorial here

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