var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Find out the level in a hierarchy oracle 9i
I am using Oracle 9.2.0. I have a query regarding how to find out the level in a hierarchy.
I have got CustomerID from the application. I would like to know at what level this id exists in the hierarchy using sql query.
Any Predefined functions in oracle to find out the level for a given id?
Or how to go about it..
Thanks in advance.
LEVEL is a pseudo-column that is provided with hierarchical queries... so, in your case all you would have to do is query/display/restrict the CustomerId column based on LEVEL.
LEVEL, parent_name, dept_name
prior dept_name = parent_name
dept_name = 'Root Parent'
ORDER BY LEVEL;