How to create a multidimensional array

Question

I am struggling a little understanding how this is done, and would really appreciate if someone could walk me through how a 2d array in PL/SQL is made?

possible duplicate of Creating or simulating two dimensional arrays in PL/SQL — user247702
– user247702, Commented Apr 6, 2014 at 23:20
See Multidimensional Collections from Oracle's PL/SQL Collections and Records. There is three different examples. — user272735
– user272735, Commented Apr 7, 2014 at 8:57

Ajay Gupta · Accepted Answer · 2014-04-07 06:09:24Z

1

You can think of the following code as each row in table2 has a collection of type table1. You can insert any number of values as is shown in BEGIN.

DECLARE

TYPE table1 IS TABLE OF NUMBER 
  INDEX BY PLS_INTEGER;

TYPE table2 IS TABLE OF table1
  INDEX BY PLS_INTEGER;
var_i table2

BEGIN

var_i (1) (1) := 1;
var_i (1) (2) := 12;

END;

edited Apr 7, 2014 at 6:09

answered Apr 7, 2014 at 5:27

Ajay Gupta

5141 gold badge5 silver badges10 bronze badges

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

Collectives™ on Stack Overflow

How to create a multidimensional array

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related