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 …

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 …