Tagged Questions

0
votes
2answers
201 views

Recursive Order by

Hi, I need help in With Recursive query order by, In Oracle, the query has rownum in the select list for connect by start with hierarchical view and was ordered by with rownum. S …
1
vote
1answer
187 views

UPDATE from recursive query

Is it possible to do an update from a recursive query in one SQL statement without using a temporary table? I am trying to set the very top boss id for each employee and I get the …