OraFAQ Forum: Forms » how to generate a tree

Home » Developer & Programmer » Forms » how to generate a tree

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to generate a tree [message #277869]

Thu, 01 November 2007 00:16

roni_a180
Messages: 45
Registered: October 2007

Member

hi

i create following table

CREATE TABLE MENUGROUPITEM
(
ID NUMBER(19) NOT NULL,
MENUGROUPID NUMBER(19),
MENUCAPTION VARCHAR2(255 BYTE),
PARENTID NUMBER(19),
)

id increametal number,

menugroupid userid (if user id 1 then populate 1 menu group tree , user id 2 then populate 2 menu group tree),

i write a sql

SELECT 1,level,menucaption,0,ID
FROM MENUGROUPITEM
where MENUGROUPID = 3
START WITH PARENTID IS not null
CONNECT BY prior ID = PARENTID

but the parfectly tree is not generate???

anybody help me

Report message to a moderator