How can I select all id's for records in single cell?
--example select of all values
select id, name, address, phone from table
select LISTAGG(id, ' ') WITHIN GROUP (ORDER BY id) from table
If you are not running Oracle 11gR2, check if wm_concat function is available and do:
select wm_concat(id) from table
Keep in mind that you might want to combine these functions with group by clauses. Check out link I gave you for more options.