oracle - 在Oracle 12c中将查询的输出转换为json

Question

我有一个查询，输出是这样的:

    1  2 3 4 5 6 7 8 9 10 11 12 13
    -  - - - - - - - - -   -  - -    
    40 20 22 10 0 0 0 0 0 0 0 0 0

我想将输出转换为一列，该列如下所示:

    output
    -----------
 {"1":40,"2":20,"3":22,"4":10,"5":0,"6":0,"7":0,"8":0,"9":0,"10":0,"11":0,"12":0,"13":0}

Answer 1

如果您希望Oracle DB服务器以JSON返回结果，则可以执行以下查询-

 SELECT JSON_OBJECT ('1' VALUE col1, '2' VALUE col2, '3' VALUE col3) FROM table