Recursive Query

From: cvnkrishna <vamsikrishna.chikkam_at_gmail.com>
Date: 14 Feb 2007 01:11:32 -0800
Message-ID: <1171444292.766120.135210_at_q2g2000cwa.googlegroups.com>

Hi all,

Oracle Version : 8.1.7.3.0

[Quoted] [Quoted] 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

desc fnd_menu_entries_vl

 Name                            Null?    Type
 ------------------------------- -------- ----
 ROW_ID                                   ROWID
 MENU_ID                         NOT NULL NUMBER
 ENTRY_SEQUENCE                  NOT NULL NUMBER
 LAST_UPDATE_DATE                NOT NULL DATE
 LAST_UPDATED_BY                 NOT NULL NUMBER(15)
 LAST_UPDATE_LOGIN               NOT NULL NUMBER(15)
 CREATION_DATE                   NOT NULL DATE
 CREATED_BY                      NOT NULL NUMBER(15)
 SUB_MENU_ID                              NUMBER
 FUNCTION_ID                              NUMBER
 PROMPT                                   VARCHAR2(30)
 DESCRIPTION                              VARCHAR2(240)


[Quoted] 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;

Regards,

Vamsi Chikkam Received on Wed Feb 14 2007 - 10:11:32 CET