Re: Is it possible to have an array in a table?

From: Ramon F Herrera <ramon_at_conexus.net>
Date: Sat, 22 Aug 2009 23:39:21 -0700 (PDT)
Message-ID: <bf28d673-25a0-49e8-9727-964d5ae3756c_at_26g2000yqk.googlegroups.com>



On Aug 22, 4:46 pm, John Hurley <johnbhur..._at_sbcglobal.net> wrote:
> On Aug 22, 4:09 pm, Ramon F Herrera <ra..._at_conexus.net> wrote:
>
> snip
>
> > Bonus question:
>
> > I believe it is possible to save an arbitrary file (let's say an MS
> > Word or PDF document) in Oracle. I'd appreciate the details on that.
>
> > TIA,
>
> > -Ramon
>
> asktom.oracle.com ... which also applies to your first question.

Thanks, John. That is indeed a helpful resource.

In reference to arrays (or VARRAYs) I have a question for you folks out there. According to the examples that I read, a VARRAY can be used when there is a small number of items. The example mentions a person/ organization with a variable number of phone numbers, of to 6.

What about a larger number of items? In that case, is it:

  • inefficient
  • inelegant
  • undesirable
  • not recommended

to use VARRAYs perhaps?

The characteristic that I value the most about arrays is the ability to iterate with an integer(s). Also important is the fact that if an item is in position 52, I can rely on it being there next time.

TIA, -Ramon Received on Sun Aug 23 2009 - 01:39:21 CDT

Original text of this message