XML Bursting via Alerts
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…
Read MoreOracle / PLSQL: LISTAGG Function
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 each GROUP based on the order_by_clause. Syntax The syntax…
Read MoreSend an email (with attachement) using Oracle PLSQL
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 varchar2, PVA_TEXT_FILE varchar2, PVA_DIRECTORY varchar2 /* Database Object */…
Read MoreChecking The performance & Advantage of using BULK COLLECT
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; BEGIN — Time a regular cursor for loop. l_start…
Read More