Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses

Re: Re: Nested table structures in Oracle & DBI

by frankus (Priest)
on Aug 14, 2002 at 12:17 UTC ( #190041=note: print w/replies, xml ) Need Help??

in reply to Re: Nested table structures in Oracle & DBI
in thread Nested table structures in Oracle & DBI

Monk Stuff
It saddened me to see whilst upvoting talexb's reply; it had been down-voted.
The contents of a scratchpad are temporary and in adding the notes here,
it's easier to provide a permanent record of the question in one location,
for the benefit of other querants and those providing answers.

Oracle Stuff
It's not clear what the field types contain.
Perhaps the easiest solution would be to write a PL/SQL function to decode the troublesome fields.

AFAIK there isn't such a thing as a nested table structure in Oracle or any other relational databases?


Brother Frankus.


  • Comment on Re: Re: Nested table structures in Oracle & DBI

Replies are listed 'Best First'.
Re: Re: Re: Nested table structures in Oracle & DBI
by perlboy26sf (Initiate) on Aug 14, 2002 at 15:50 UTC
    Actually, in fact there are such things (and why was this marked as a duplicate?)
    While oracle is in fact at it's core a relational database structure, oracle8i and above provide some nifty objectish approaches to both storing and recovering data in more complex structures. Think of the fields represented here with *_NT as being tables within the row elements of the interface table. In perl you would call this strucrure a multi dimensional hash, where the keys *_NT point to embedded hashes as their values. The upshot of doing something like this is that when you are dealing with many tables which have extremely large counts of row data, you do not have to do explicit joins to find the data you wish to retrieve, thus making things run ALOT faster by avoiding the need to create a large cartesian product and then eliminating rows before retrieving your data. I cant possibly have been the first person to try this. <:) --perlboy
      Okay, I read the blurb, and it sounds pretty grotesque.
      Personally I'd just do two SQLs rather than gild a lily...
      and not knit the code so closely to one database manufacturer.

      I cant possibly have been the first person to try this. <:)
      You aren't.. However, you'll not want to hear that..
      From what I've read they're akin to LOBS, I guess you've checked this on CPAN?


      Brother Frankus.


Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://190041]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (7)
As of 2020-05-28 22:26 GMT
Find Nodes?
    Voting Booth?
    If programming languages were movie genres, Perl would be:

    Results (166 votes). Check out past polls.