PLSQL Sorgu Sonucunu Tek Satirda Birleştirme

 Varsayalım ki EMPLOYEES tablosundan çalışan isimlerini birleştirmek istiyorsunuz:

DECLARE
   employee_names VARCHAR2(4000);
BEGIN
   SELECT LISTAGG(first_name, ';') WITHIN GROUP (ORDER BY first_name)
   INTO employee_names
   FROM EMPLOYEES;

   DBMS_OUTPUT.PUT_LINE(employee_names);
END;