Hi,
I have a database project with a hierarchy table and I wish I could replicate my table with a custom data type, but I've been having trouble...
I've been trying of different ways, especially with the bulk collect but with not successful results.
Here an example of my types definition:
CREATE OR REPLACE TYPE element_type;
/
CREATE OR REPLACE TYPE element_table IS TABLE OF REF element_type;
/
CREATE OR REPLACE TYPE element_type AS OBJECT (
id NUMBER(5),
name VARCHAR2(5 CHAR),
childs element_table
) NOT FINAL;
/
Anybody knows if its there a way of populate my "NESTED TABLE OF REF " type in a SELECT statement?
Thanks in advance!