sql 查询转换json
sqlserver：https://learn.microsoft.com/zh-cn/sql/relational-databases/json/how-for-json-converts-sql-server-data-types-to-json-data-types-sql-server?view=sql-server-ver16
--2016后使用 FOR JSON select *from @sale for json auto
oracle：
1.参考：https://dgrt.cn/a/2558773.html?action=onClick
2.oracle 12c - Oracle 19C：参考 https://www.modb.pro/db/233455
select JSON_OBJECT(*) from v$database;
{
"DBID": 2241305521,
"NAME": "ORCL",
"CREATED": "2021-11-10T17:34:41",
"PRIOR_RESETLOGS_TIME": null
}
SELECT JSON_OBJECT(
'log_mode' : name||' is '||log_mode||' mode;',
'force_logging' : force_logging,
'supplemental_log_data_min' : supplemental_log_data_min
)
FROM v$database;
{
"log_mode": "BILL is ARCHIVELOG mode;",
"force_logging": "YES",
"supplemental_log_data_min": "YES"
}