https://eco.dameng.com/document/dm/zh-cn/pm/json

测试代码：

CREATE TABLE T(
id INT NOT NULL,
name VARCHAR(100),
age INT,
PRIMARY KEY(id)
) ;
INSERT INTO T(id, name, age) VALUES (1, 'john doe', 25);
INSERT INTO T(id, name, age) VALUES (2, 'jane smith', 30);
INSERT INTO T(id, name, age) VALUES (3, 'bob johnson', 22);
COMMIT;


select jsonb_agg(row_to_json(x))::VARCHAR2 J_ARR from T x;