select.sh

select.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;
                                 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     
B464467C808C4CFBA6C0EBD76CF5A73E    05-AUG-20 11.15.57.787655000 PM    05-AUG-20 11.15.57.787655000 PM    dominic    13