Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> QUERY problem with objects and nested tables in Oracle8
Hello,
I'm experimenting with the conversion of a Dijkstra matrix flat-file to an efficient Dijkstra table in Oracle8 using objects. Building it all up was not too hard, but I have serious problems with querying it !
This is how its build up (the actual problem is stated at the end:
Up until now no problems, .., in the above way I simulate a 2-dimensional
flatfile in a database table
with a nested table. I populated it, .., but now I want to query it !
I want to select exactly 1 object from the table from which I can extract
the 'distance' value between
the 2 nodes. I'm quite confidend that I need the 'THE' operator and that I
have to use the beginning and
the ending node as constraints in the query in the where clause.
It seems to be a very simple problem, ..., but the more I get to read the
more I'm getting afraid that
this isn't possible yet ! (its my personal opinion that if this isn't
possible then Oracle shouldn't claim
that they have implemented objects and nested tables, I hope this will not
be the case). The books
are very very brief with their information regarding the combination of
nested tables and objects and
selecting atomary object from those nested tables.
I hope anyone can help me with this one.
regards,
Stefan Gyles.
Received on Sat Dec 26 1998 - 00:00:00 CST