1600 PMP mock questions 1400 CAPM mock questions 800 SCJP 6 mock questions 600 OCAJP 7 mock questions 590 OCPJP 7 mock questions 556 SCWCD 5 mock questions 500 OCEJWCD 6 mock questions pdfDownload (java,struts, hibernet etc)

ORACLE Tutorials

Example of using collection type in Oracle

CREATE OR REPLACE PACKAGE pack1
IS
TYPE etable IS TABLE OF employees%ROWTYPE
INDEX BY BINARY_INTEGER;

PROCEDURE proc1 (emptable OUT etable);
END;
/

CREATE OR REPLACE PACKAGE BODY pack1
IS
PROCEDURE proc1 (emptable OUT etable)
IS
i BINARY_INTEGER := 0;
BEGIN
FOR c2 IN (SELECT *
FROM employees
WHERE salary > 10000)
LOOP
emptable (i) := c2;
i := i + 1;
END LOOP;

FOR i IN emptable.FIRST .. emptable.LAST
LOOP
DBMS_OUTPUT.put_line ('VALUE OF I :' || emptable (i).employee_id);
END LOOP;
END;
END;
/

SHOW ERRORS

Reviews and Comments


PMP, CAPM, PMI is a registered certification mark of the Project Management Institute, Inc

Copyright © www.techfaq360.com 2016


About US | Contact US | Privacy Policy | Terms and Conditions  | Website disclaimer  | Cancellation and Refund Policy  | Shipping & Delivery Policy