File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes abstract data type Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "abstract data type" Watch "abstract data type" New topic

abstract data type

vasu maj
Ranch Hand

Joined: Jul 12, 2001
Posts: 396
Hi Tom,
I have a situation in which I have to use nested tables. The problem is they are nesting too deep, i.e, we have nested to the fifth level. We dont have any problem as such using the tables individually but while retrieving the data using the tables in which they are nested, we are finding it very difficult. Nesting the tables was our solution for encapsulating the data. Is there any other better way to do this?
I will appreciate your response...

What a wonderful world!
Thomas Kyte

Joined: Jul 15, 2001
Posts: 6
Can you describe what you mean by 5 levels deep with regards to a nested table type?
Until Oracle9i, collections only go one level -- I need to know whether you are talking about a multi-level collection in 9i or if you have some specific construct you are using in Oracle8i.
An example of what you've done would be useful.

Thomas Kyte ( <A HREF="" TARGET=_blank rel="nofollow"></A> <BR>Expert one on one Oracle, programming techniques and solutions for Oracle.<BR> <BR>Opinions are mine and do not necessarily reflect those of Oracle Corp
I agree. Here's the link:
subject: abstract data type
It's not a secret anymore!