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:41:02 -0700 (PDT)
Message-ID: <5dd546ea-932a-49db-a66d-9fc5888b69aa_at_k19g2000yqn.googlegroups.com>
On Aug 23, 2:39 am, Ramon F Herrera <ra..._at_conexus.net> wrote:
> 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
Date: Sat, 22 Aug 2009 23:41:02 -0700 (PDT)
Message-ID: <5dd546ea-932a-49db-a66d-9fc5888b69aa_at_k19g2000yqn.googlegroups.com>
On Aug 23, 2:39 am, Ramon F Herrera <ra..._at_conexus.net> wrote:
> 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
I meant "up to 6"
-RFH Received on Sun Aug 23 2009 - 01:41:02 CDT