Sometimes you may be dealing a situation that you need to store JSON data into your table. As a developer we might be thinking, we could use programming language to retrieve a value from JSON data by parsing each value.

Wait.., Oracle 12c and above provided a inbuilt function where you can use it immediately.

Assuming your JSON structure is below and you would like to retrieve the First Name from the first row record:

{”First Name”:”Leonardo”,”Last Name”:”Da Vinci"},

{”First Name”:”Monalisa”,”Last Name”:”-”}

select json_value(form_data,’$[0].”First Name”’) from customer

$[ ] is the JSON array index, and 0 — indicates the first index of the row { … }



When your docker suddenly crashed, it will leave out a residue daemon file and due to this you will be not able to restart the docker

The error:

dockerd-current[9743]: unable to configure the Docker daemon with file /etc/docker/daemon.json: the following directive

Solutions: Is to remove the json file

rm /etc/docker/daemon.json



A common mistake done by developers when they raise merged request to the code repository, you probably seen a lot of spaces in the code, unindent, missing bracelets, camel case or non came case and others, that you can easily spot on as code reviewer.

As developer we need to keep the code to be consistent in terms of code style and clean up, is regardless of who is the coder.

Let’s start.

Applying to IDE

Download the java Google code style file from the repository here.

Open your Eclipse and click on Window > Preferences > Java > Code Style > Formatter

Click import and select the eclipse-java-google-style.xml file

Eclipse Formatter

And to apply changes whenever we click on the save button in eclipse. Please open Window > Preferences > Java > Editor > Save Actions



Whenever you encountered a VM issue and no documentation on how to rebuild the active running application . The only way is to salvage the existing image by downloading as a tar file.

docker save -o <output.tar> <image name>docker save -o application.production.tar application:production

And when your new VM is ready, you can re-import again the image and run it.

docker load --input application.production.tar