Skip to content
Advertisement

How to Convert multiple rows into one with comma as separator – Oracle db

I have an oracle table which has id and order_id columns. Table have same order_id with different id’s.

How can I write a select for group same order_ids, and show in one line which seperated with comma;

Select result should be like that;

Advertisement

Answer

LISTAGG

User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement