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

?

1 2 3

--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

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

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" }