select2.sh

select2.sh

SQL> select 
  2  tc.id, tc.created_on, tc.last_modified,
  3  tc.json_document.name, tc.json_document.age
  4  from testcollection tc
  5  where tc.json_document.name = 'todd'; 
                                 ID                         CREATED_ON                      LAST_MODIFIED    NAME    AGE 
___________________________________ __________________________________ __________________________________ _______ ______ 
DBBA0A6CF5AB4093A0819A53CDE3CD99    05-AUG-20 11.15.50.638289000 PM    05-AUG-20 11.15.50.638289000 PM    todd    43