IT'S DO
article thumbnail
[Oracle] oracle 버전 확인.
DB/Oracle 2022. 12. 8. 15:39

SELECT * FROM PRODUCT_COMPONENT_VERSION;

article thumbnail
[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 ..