Tagged Questions
1
vote
1answer
58 views
Using Oracle hierarchical queries for transposing field value into rows
One column in my table stores list of values separated by comma (I know it's a poor design, but refactoring is not an option at the current moment). I seem to come up with a working solution but I'm ...
2
votes
2answers
120 views
Hierarchy query with 3 tables
I am not able to understand how to achieve a hierarchy accessing 3 tables. That is, I have Table1, Table2 and Table3 where:
Table1 (ID_table1, name_c, size)
Table2 (ID_table2, ID_table1, name_l, ...
7
votes
3answers
647 views
Oracle: How do I query a Hierarchical table?
Background
This is for the construction of some views we'll be using for reporting.
I have an table of locations, the key fields being "location" and "parent".
The structure that these two fields ...
1
vote
2answers
411 views
Oracle hierarchical query question (start with … connect by … )
From the Oracle documentation:
To find the children of a parent row, Oracle evaluates the PRIOR
expression of the CONNECT BY condition for the parent row and the
other expression for each row ...
1
vote
2answers
989 views
hierarchical query in oracle
Suppose I want to perform data migration operation for which I would like to load the parent tables first and then the child tables for the obvious reason. Some of these tables play dual role. Assume ...
