
[Oracle, postGresql] json_arrayagg , json_object, json_agg 사용법
DB/Oracle
2022. 12. 8. 15:18
[Oracle] Json_arrayagg , json_object -> oracle query 데이터 값을 json_object 값으로 받을 때 사용 # query select * from t_board; # query select json_arrayagg( json_object( key 'board_idx' value b.board_idx, key 'title' value b.title, key 'contents' value b.hit_cnt, key 'creator_id' value b.creator_id, key 'updater_id' value b.updater_id, key 'delete_yn' value b.delete_yn ) ) as json_data from t_board b ORDER ..