var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Hierarchical Queries and Self-Referencing objects.
i have the following table:
create table A1 as (
and i have a self-referencing type:
create type A1_T as object(
p_ref REF A1_T
what i essentially want to after this is to create an XML output using dbms_xmlgen that will take a row and traverse the parents (3 levels say). and populate the data(for example)
<SOME_DATA>data for 5</SOME_DATA>
<SOME_DATA>data for 3</SOME_DATA>
<SOME_DATA>data for 1</SOME_DATA>
any thoughts will be appreciated.
For the SQL to populate those records:
read oracle (or serach Google) documentation about CONNECT BY.
It's used for tables like yours (Bill Of Material).
Hierarchical queries and Objects.
hi edwin -
i have used connect-by construct for hierarchical queries. the specific problem
to populate the self-referencing objects and using the REF to construct into
a recursive XML is where, i have run out of ideas.,