Does anyone have an example of a PL/SQL implementation of a tree abstract data type? Before starting from scratch I wondered if any short-cuts were available. On Google and the search here I can't find the tree ADT for the CONNECT BY forest...
A general (not binary) tree is the abstraction necessary to model operations in a process. We want to do this using a PL/SQL package/types or SQL object types without additional database tables and SQL CONNECT BY or recursive subqueries as (a) the tree structures have to be reusable across several modules; (b) the logic for generating the tree is not all based on database data (and when it is it operates at several removes from it); and (c) we'd prefer to avoid creating database tables for the purposes of processing metadata.
Oracle 11.2.0.4 EE