How to populate a single-dimension array with result of a query?

Question

I have to populate the result of a query into an array in my pl/sql proc.

For example, I have a employeeId empArr (TYPE empArr IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;) and i want to populate this array with the result of a sql statement :

    select empId where dept = 'accounts'.

Is there a way to do this ? Or would you suggest using cursors to do the job ?

Thx Cshah

Dave Costa · Accepted Answer · 2019-06-19 00:04:52Z

6

DECLARE
  TYPE empArr IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
  myEmpArr  empArr;

BEGIN

  SELECT empID
    BULK COLLECT INTO myEmpArr
    FROM empTable
    WHERE dept='accounts';

  -- Do your stuff

END;
/

edited Jun 19, 2019 at 0:04

answered Oct 14, 2009 at 14:44

Dave Costa

48.3k8 gold badges61 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Eddie Prislac Over a year ago

I don't see where you're setting which table to perform the select statement on in the above example.

Dave Costa Over a year ago

@EddiePrislac you're quite right, I left it out (maybe because I copied the query form the question which also had no table name). Fixed now.

Collectives™ on Stack Overflow

How to populate a single-dimension array with result of a query?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related