JSON data is nice, but it is difficult to work with directly in Oracle. By converting it to relational data (rows and columns) we can easily work with it. This video demonstates how to convert JSON data to relational data using json_table.
Thank you so much for making this video. You are a great teacher; you've taken an area that terrifies me and actually made it fun! Parsing JSON and XML is always a huge pain for me and this video saved my day. Thank you!!!!
Thank you so much! I really appreciate this. Superb explanation.
Could you also post update/delete queries and few join examples as well when ever you get time? That would actually make this series complete :)
Once again, thank you for knowledge sharing
Thanks for watching!
I don't think I'll be making any more Oracle videos though. The database installation on my old computer was horrible, and I don't want to add it on my new computer.
If you have any questions though, you can ask in one of the videos, or you can email me at [email protected]
Download the appropriate system image for your device below, then unzip it to a safe directory.
Connect your device to your computer over USB.
Start the device in fastboot mode with one of the following methods:
Using the adb tool: With the device powered on, execute:
Using a key combo: Turn the device off, then turn it on and immediately hold down the relevant key combination for your device.
If necessary, unlock the devices bootloader using one of the following methods:
If you are updating a Nexus or Pixel device that is manufactured in 2015 or later (for example, a Nexus 5X, Nexus 6P, Pixel, Pixel XL, Pixel 2 or Pixel 2 XL device), run this command:
For Pixel 2: To flash the bootloader, Pixel 2s boot loader must be updated to at least Oreo MR1s version first. This may be done by applying an over-the-air (OTA) update, or sideloading a full OTA with the instructions on that page.
For Pixel 2 XL only with loader version prior to TMZ20a: the critical partitions may also need to be unlocked before flashing. The unlock can be performed with this command, and should NOT be done on other devices:
If you are updating an older device, run this command:
The target device will show you a confirmation screen. (This erases all data on the target device.)
See Unlocking the bootloader for more detailed instructions.
Open a terminal and navigate to the unzipped system image directory.