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;

Detaylar

IFS Database Automatic Shudown With Batch File

 Stopstart.bat :

set oracle_sid=prod

sqlplus sys/Password as sysdba @C:\stopp.sql

stopp.sql:

shutdown immediate

startup

Detaylar