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

Oracle SQL JSON nested loop

This is a very cool way to do a depth first traversal of JSON that I have test in the Oracle 19c version of the database So the cool part is col3 clob format json with wrapper path '$.col3[*]' that stores a JSON objects for col3 so that the outer loop does not care what the object contents are the inner loop then parses this JSON. This is a very compact and readable way of traversing all of your JSON begin for rec1 in ( select col1, col2, col3 from json_table( '{"col1": 1, "col2" : 2, col3 : {"col3foo1" :4, "col3foo2": 5}}' , '$[*]' columns col1 varchar2 ( 200 ) path '$.col1' , col2 varchar2 ( 200 ) path '$.col2' , col3 clob format json with wrapper path '$.col3[*]' ) ) loop dbms_output.put_line( 'col1=' ...
Read more

Linux over the last 20 years

Linux has come a long way in the last 20 years. Surprisingly Linux usage at home seems to be shrinking, but growing in the enterprise. I think 5 years back the only serious alternative to Windows at home was Linux. But with the popularity of Apples iMac and Macbook, the usage of Linux is declining at home. See the following infographic on how Linux and the Internet  has changed over the last 20 years
Read more