I just learnt a new syntax. With 12.1.0.2, you can dive into your JSON document within sql, it looks a bit unusual to me
SQL> CREATE TABLE t
(b CLOB CHECK (b IS JSON));
Table created.
SQL> insert into t(b) values
('{"c":{"d":{"e":1}}}');
1 row created.
SQL> select a.b.c.d.e from t a;
C
----------------------
1
Largely inspired from Tom Kyte session
Laurent,
maybe good to know that there is more than only the JSON a dot notation. Have a look at the overview presentation here: http://www.liberidu.com/blog/2014/09/12/oracle-database-12-1-0-2-0-getting-started-with-json-path-expressions/
It shows all operators and options now build in in 12.1.0.2 and direct URL links to the documentation.
Greetings
Marco