|
|
|
|
|
by discordance
1116 days ago
|
|
"Thanks ChatGPT. Could you please write that for MySQL and additionally for Oracle?" MySQL: SELECT GROUP_CONCAT(columnName SEPARATOR ', ') FROM tableName; Oracle: SELECT LISTAGG(columnName, ', ') WITHIN GROUP (ORDER BY columnName) FROM tableName; I mean, it's not a big deal.. you just give have to give it a little nudge. |
|