Oracle 从JSON文档中提取属性

(Reports : 
[( 'reportname': 'abc',
    'Sort order':'abc',
    'sortlabel':'name',
     'columns' :[ ( 'component' : 'q_test1', 
                              'column_order' : '1'
                             ),
                          ( 'component' : 'q_test2', 
                              'column_order' : '2'
                             )]
 )])

SQL> create table t ( j varchar2(1000), constraint chk check ( j is json ));

Table created.

SQL>
SQL> insert into t values ('
  2  {Reports :
  3  [{ "reportname": "abc",
  4      "Sort order":"abc",
  5      "sortlabel":"name",
  6       "columns" :[ { "component" : "q_test1",
  7                                "column_order" : "1"
  8                               },
  9                            { "component" : "q_test2",
 10                                "column_order" : "2"
 11                               }]
 12   }]}');

1 row created.

SQL>
SQL> select
  2    t.j.Reports."reportname" n,
  3    t.j.Reports."Sort order" s,
  4    t.j.Reports."columns"."component" c
  5  from t t;

N                              S                              C
------------------------------ ------------------------------ ---------------------------
abc                            abc                            ["q_test1","q_test2"]

1 row selected.