Hi everyone!!

I have selected in a view records laid out like the following:

item1 item2 item3 item4
item1 item2 itemA item4
item1 item2 itemB item4
item8 item9 item11 item5
item8 item9 item1C item5

What I am showing is that the fourth column is the only changing field, which is fine. But, now I want to out put the records from the above view to look like:

item1 item2 item3 itemA itemB item4
item8 item9 item11 item1C item5

I am trying to create some type of array for the 4th column to capture that field and to output it contiguously for item1 and do the same for item8. So far, the below is what I am trying to do.. Any help would be highly appreciated:


Declare
TYPE llnum is view of bobview.localleasenumber%TYPE;

v_cnt integer :=0;

V_ccsd_hold varchar2(8);
v_llnum_hold varchar2(20);

v_ccsd varchar2(8);
v_TSRNUM VARCHAR2(14);
v_TSONUM VARCHAR2(10);
v_LOCALLEASENUMBER VARCHAR2(20);
v_PDC VARCHAR2(6);
v_TICCODE VARCHAR2(1);
v_NUMERICBANDWIDTH NUMBER(14);
v_MEDIACKTTRAV VARCHAR2(3);
v_TSRRCVD DATE;
v_SVCREQDATE DATE;
v_TSODTG DATE;
v_SVCORDERDATE DATE;
v_CRPDATE DATE;
v_CRPTYPE VARCHAR2(1);
v_GEOLOC VARCHAR2(8);
v_SCC VARCHAR2(2);
v_ENR VARCHAR2(3);
v_CONTROLOFFICEGEL VARCHAR2(8);
v_CONTROLOFFICESCC VARCHAR2(2);
v_CONTROLOFFICEENR VARCHAR2(3);
v_TASK VARCHAR2(50);

CURSOR c1 is
Select * from bobview

BEGIN
Open c1;
fetch c1 BULK COLLECT into v_ccsd, v_TSRNUM, v_TSONUM,
v_LOCALLEASENUMBER, v_PDC, v_TICCODE,
v_NUMERICBANDWIDTH, v_MEDIACKTTRAV, v_TSRRCVD,
v_SVCREQDATE, v_TSODTG, v_SVCORDERDATE, v_CRPDATE,
v_DATE v_CRPTYPE, v_GEOLOC, v_SCC, v_ENR, v_CONTROLOFFICEGEL,
v_CONTROLOFFICESCC, v_CONTROLOFFICEENR, v_TASK;

v_llnum_hold := v_localleasenumber;

for i in v_ccsd.FIRST..v_ccsd.LAST LOOP

if v_localleasenumber = v_llnum_hold

DBMS_OUTPUT.PUT_LINE(v_ccsd(i) ||' '||v_llnum_hold(i));

END LOOP;

END;
/