derefing a nested table full of refs

[AVataRR]

okay.. say I gots me a table and each row of this table has a nested
table full of refs.. I know I have to somehow get to each "tuple" of the
nested table and deref them individually, but PL/SQL being worse than
BASIC, I have absolutley no idea of how to do this.



helpy?

 

[AVataRR]

oopsie I don't know how this got posted here, but I meant to put it
up in the SQL/PL SQL board. Can someone please move it?

 

[Gregory Toomey]

It was a dark and stormy night, and AVataRR managed to scribble:

oopsie I don't know how this got posted here, but I meant to put it
up in the SQL/PL SQL board. Can someone please move it?

NO!

But referring to your original question, a relationaly database may not be the best way to store complex network relationships. A object oriented database may be more appropriate.
Relational calculus knows nothing about dereferencing.

gtoomey

 

[ctcgag]

okay.. say I gots me a table and each row of this table has a nested
table full of refs.. I know I have to somehow get to each "tuple" of the
nested table and deref them individually, but PL/SQL being worse than
BASIC, I have absolutley no idea of how to do this.

You know, I think you may have accidentally posted this to the right
news group. Because if I had to do that, I'd do in Perl rather than
PL/SQL.

But YMMV. I know some of the real Oracle devotees would disagree with me.

Xho

 

[AVataRR]

gleh, I feel exactly the same way as you guys. unfortunatley this is for
a little assignment and I have no say in the matter. I wonder if I
can get some sort of exemption for that little part, using some sort of
official protest.



may oracle and plsql/sql die.