DECLARE
TYPE nt_fName IS TABLE OF VARCHAR2 (20);
TYPE nt_lName IS TABLE OF VARCHAR2 (20);
fname nt_fName;
lName nt_lName;
BEGIN
SELECT first_name, last_name
BULK COLLECT INTO fName, lName
FROM employees;
--Print values from the collection--
FOR idx IN 1..fName.COUNT
LOOP
DBMS_OUTPUT.PUT_LINE (idx||' - '||fName (idx) ||' '||lName (idx));
END LOOP;
END;
TYPE nt_fName IS TABLE OF VARCHAR2 (20);
TYPE nt_lName IS TABLE OF VARCHAR2 (20);
fname nt_fName;
lName nt_lName;
BEGIN
SELECT first_name, last_name
BULK COLLECT INTO fName, lName
FROM employees;
--Print values from the collection--
FOR idx IN 1..fName.COUNT
LOOP
DBMS_OUTPUT.PUT_LINE (idx||' - '||fName (idx) ||' '||lName (idx));
END LOOP;
END;
USES :
- BULK COLLECT: SELECT statements that retrieve multiple rows with a single fetch, improving the speed of data retrieval
- FORALL: INSERTs, UPDATEs, and DELETEs that use collections to change multiple rows of data very quickly
👋 Hi, I'm Suriya — QA Engineer with 4+ years of experience in manual, API & automation testing.
📬 Contact Me | LinkedIn | GitHub
📌 Follow for: Real-Time Test Cases, Bug Reports, Selenium Frameworks.
No comments:
Post a Comment