2 ms·
"Thanks ChatGPT. Could you please write that for MySQL and additionally for Oracle?" MySQL: SELECT GROUP_CONCAT(columnName SEPARATOR ', ') FROM tableName; Ora
by discordance 3y 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.