Breaking News: Grepper is joining You.com. Read the official announcement!

pl/sql bulk collect clause single column

Dark Dunlin answered on January 17, 2024 Popularity 3/10 Helpfulness 1/10

answer pl/sql bulk collect clause single column

related pl/sql bulk collect clause more columns

pl/sql bulk collect clause single column

Comment

DECLARE
   c_limit PLS_INTEGER := 100;

   CURSOR employees_cur
   IS
      SELECT employee_id
        FROM employees
       WHERE department_id = department_id_in;

   TYPE employee_ids_t IS TABLE OF 
      employees.employee_id%TYPE;

   l_employee_ids   employee_ids_t;
BEGIN
   OPEN employees_cur;

   LOOP
      FETCH employees_cur
      BULK COLLECT INTO l_employee_ids
      LIMIT c_limit;

      EXIT WHEN l_employee_ids.COUNT = 0;
   END LOOP;
END;

Popularity 3/10 Helpfulness 1/10 Language sql

Source: blogs.oracle.com

Tags: bulk-collect clause sql

Link to this answer
Share Copy Link

Contributed on Jan 17 2024

Dark Dunlin

0 Answers Avg Quality 2/10

Closely Related Answers

pl/sql bulk collect clause more columns

Comment

DECLARE
   TYPE two_cols_rt IS RECORD
   (
      employee_id   employees.employee_id%TYPE,
      salary        employees.salary%TYPE
   );

   TYPE employee_info_t IS TABLE OF two_cols_rt;

   l_employees   employee_info_t;
BEGIN
   SELECT employee_id, salary
     BULK COLLECT INTO l_employees
     FROM employees
    WHERE department_id = 10;
END;

Popularity 1/10 Helpfulness 1/10 Language sql

Source: blogs.oracle.com

Tags: bulk-collect clause sql

Link to this answer
Share Copy Link

Contributed on Jan 17 2024

Dark Dunlin

0 Answers Avg Quality 2/10

pl/sql bulk collect clause single column

Contents

More Related Answers

pl/sql bulk collect clause single column

Closely Related Answers

pl/sql bulk collect clause more columns

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.