create or replace function get_name(p_date in date) return varchar2 is
Result varchar2(100);
cursor rad_cursor(v_date date) is
select distinct name from table_name
where ctime=v_date;
v_count Number;
begin
v_count:=0;
Result:='';
for v_sor in rad_cursor(p_date) loop
if v_count=0 then
Result:=v_sor.name;
v_count:=v_count+1;
else
Result:=Result||','||v_sor.name;
end if;
end loop;
return(Result);
end get_name;
/
select ctime,get_name(ctime) from table_name group by ctime;