tree in lov [message #318854] |
Thu, 08 May 2008 04:29  |
salwa
Messages: 76 Registered: December 2007
|
Member |
|
|
hi all
how to create tree in LOV
my code is
SELECT -1,level,gldescription||' ('||glmapcode||')',null,glmapcode
FROM GLACCOUNT g
START WITH glid = 2000000
CONNECT BY NOCYCLE prior glID = glPARENTID and GLLEVEL <>0
order siblings by gldescription asc
|
|
|
Re: tree in lov [message #319078 is a reply to message #318854] |
Fri, 09 May 2008 00:14  |
 |
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
What is the problem you are trying to solve?
You have your 'select' statement. Have you tried creating a 'record_group' using it?
David
|
|
|