Initially there was an alert in the system but due to alignment Issues we planned to go with trigger and XML Bursting. As there was already Alert in the system so we decided to use it instead of [...]

Oracle / PLSQL: LISTAGG Function how to use the Oracle/PLSQL LISTAGG function with syntax and examples. Description The Oracle/PLSQL LISTAGG function concatenates values of the measure_column for [...]

Send an email (with attachement) using Oracle PL/SQL create or replace procedure SEND_EMAIL_WITH_TXT_ATTACH ( PVA_SENDER varchar2, PVA_RECEIVER varchar2, PVA_SUBJECT varchar2, PVA_MESSAGE [...]

SET SERVEROUTPUT ON DECLARE TYPE t_bulk_collect_test_tab IS TABLE OF bulk_collect_test%ROWTYPE; l_tab t_bulk_collect_test_tab; CURSOR c_data IS SELECT * FROM bulk_collect_test; l_start NUMBER; [...]