What is the best PLSQL solution to this problem?

From: javadude <javadude_at_here.com>
Date: Wed, 20 Jun 2001 00:29:40 GMT
Message-ID: <3B2FEE74.4C76EC44@here.com>

I need repetitive access to a data structure that consists of

  KEYWORD      ARRAY (the values are separated by commas)
  -------      ----------------------------
  key1         12,N,N,4
  key2         5,N,23,24,26,N,N,N
  key3         1,2,5,6,7,8

.
.
.

N; where N < 30

and want the best performance.

I want to do it in PL/SQL only with NO tables being created in the database. Since, no
one in the group is familiar with Oracle objects except me and I have just started using them so I would like to avoid them if there is way to do it without them. DB version is 8.1.7 and beyond. Essentially what I want is a hash of arrays, which in Perl is so easy to do but how do you do it in PLSQL given the constraints mentioned?

? Received on Tue Jun 19 2001 - 19:29:40 CDT