This video demonstrates some examples on querying JSON objects in Oracle12C. Dot notation is used to query the objects in this video, while other videos of mine will cover other query methods.
Need one-on-one help with your project? I can help through my coaching program. Learn more here: https://prettyprinted.com/coaching