-
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;
/
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|