Write a procedure with Collections
Hi All,
v_ctr INTEGER;
v_seg_l1_cd dim_customer_segments.seg_l1_cd%TYPE;
v_commit_ctr NUMBER; CURSOR c_normalize_seg
IS
SELECT DISTINCT /*+ INDEX (dim_customer_segments(hist_ind) */ dim_customer_nr
FROM dim_customer_segments
WHERE hist_ind = 'V'
AND seg_type_cd IN ('BIC_SER', 'SSPSELL')
I have written following PL/SQL block.I want to write a procedure for the following PL/SQL code with COllections concept. I am not that much aware of Collections. So can any one please help me to write a procedure for the following PL/SQL coding.
[code]
DECLAREv_ctr INTEGER;
v_seg_l1_cd dim_customer_segments.seg_l1_cd%TYPE;
v_commit_ctr NUMBER; CURSOR c_normalize_seg
IS
SELECT DISTINCT /*+ INDEX (dim_customer_segments(hist_ind) */ dim_customer_nr
FROM dim_customer_segments
WHERE hist_ind = 'V'
AND seg_type_cd IN ('BIC_SER', 'SSPSELL')
0