JSON Array Aggregation and CONCATenation in Postgre and OracleDB
Personal
OracleDB
PostgreSQL
- compares some aggregation or json functions
- includes unsolved issues
- compares some aggregation or json functions
- includes unsolved issues
Description :
JSON Array Aggragation and CONCAT
| Command in PostgreSQL | Command in OracleDB |
|---|---|
| ARRAY_AGG | JSON_ARRAYAGG |
| anyarray[1] | JSON_VALUE(anyarray, '$[0]') |
| CONCAT(1,2,3) = '123' | CONCAT(CONCAT(1,2),3)='123' |
| ST_Envelope(geometry) | SDO_GEOM_MBR(geometry) |
Unsolved Issues
| Solution in PostgreSQL | Solution in OracleDB |
|---|---|
| json_build_object() | JSON_OBJECT? |
| array | STRARRAY? |
| unnest & array_position | unsolved |
Example :
2025 Jan