collection methods in pl sql
DECLARE
CURSOR c_cust_cur IS
SELECT ENAME, EMPNO, SAL, DEPTNO FROM EMP; ---smple cursor
TYPE v_cust_cur IS RECORD(
ENAME VARCHAR2(60),
EMPNO VARCHAR2(60),
SAL VARCHAR2(60),
DEPTNO VARCHAR2(60)); ---record type
TYPE cust_cur_tbl IS TABLE OF v_cust_cur INDEX BY BINARY_INTEGER; --PL/SQL - Collections Associative array (or index-by table)
-- or index by binary_integer|pls_integer|VARCHAR2(size);
---declaration of variable
v_cust_cur_tbl cust_cur_tbl;
v_data_clob CLOB := EMPTY_CLOB();
v_from VARCHAR2(100);
v_to VARCHAR2(32700);
BEGIN
OPEN c_cust_cur;
FETCH c_cust_cur BULK COLLECT --Bulk collect
INTO v_cust_cur_tbl;
CLOSE c_cust_cur;
BEGIN
v_cust_cur_tbl.delete(1); --Pl SQl Methods
/* FOR i IN 1 .. v_cust_cur_tbl.COUNT LOOP
or we ca write also output will be same */
FOR i IN v_cust_cur_tbl.first .. v_cust_cur_tbl.last LOOP
/* Retrive data from record */
v_data_clob := v_cust_cur_tbl(i).ENAME || '",' || '"' || v_cust_cur_tbl(i)
.EMPNO || '",' || '"' || v_cust_cur_tbl(i).SAL || '",' || '"' || v_cust_cur_tbl(i)
.DEPTNO;
dbms_output.put_line(v_data_clob);
dbms_output.put_line(v_cust_cur_tbl.first); --Pl SQl Methods
dbms_output.put_line(v_cust_cur_tbl.last);-- Pl SQl Methods
dbms_output.put_line(v_cust_cur_tbl.count);-- Pl SQl Methods
END LOOP;
END;
END;
--Thanks friend we will give code in description box copy and execute ....
enjoy ... try to do execute some methods yourself
