Re: Recursive Query

On Feb 14, 10:11 am, "cvnkrishna" <vamsikrishna.chik..._at_gmail.com> wrote:
> Hi all,
>
> Oracle Version : 8.1.7.3.0
>
> Can anyone please help in creating the recursive query on the below
> table with menu_id and sub_menu_id. Connect-by is not working
[...]
> 1) For every Menu_id, Sub_menu_id can be null;
> 2) For every Menu_id, Can have many Sub_menu_id;
> 3) For every Sub_menu_id, can have many menu_id;

... and so on, w/o depth limit ?
Any chance to get to an ancestor ID (loop) ?

Shortly, is your data structure a tree, a graph ?

--
David