help on start with and connect by with parameter 
Author Message
 help on start with and connect by with parameter

I'm doing a tree that can take a parameter. The parameter is the
father #. Because I want to let the user have the choice of seeing the
whole tree or part of the tree depending on the parameter the user had
chosen.
E.g. if the user enter 1 the function will only show this tree part
with all his children, but if the user enter 0, it will show the whole
tree.

This is the syntax that i'm using

select child
FROM tableX
START WITH (father) = &akey or &akey=0
CONNECT BY father =  PRIOR child

Without the &akey=0, it's working. But with the 0, it doesn't show
anything.

Please help me. Thanks



Mon, 24 May 2004 00:26:39 GMT
 help on start with and connect by with parameter

[...]
Quote:
>This is the syntax that i'm using

>select child
>FROM tableX
>START WITH (father) = &akey or &akey=0
>CONNECT BY father =  PRIOR child

>Without the &akey=0, it's working. But with the 0, it doesn't show
>anything.

>Please help me. Thanks

Hi,

I've tested your case just now. It works fine.
The only change I've applied is CONNECT BY PRIOR father = child.
May be you missed some details in your posting?

Regards,

--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com



Mon, 24 May 2004 14:07:16 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. HELP: Can't shutdown/start instance even when I'm connected as SYSTEM/MANAGER

2. SQL Help: Extended use of START WITH CONNECT BY

3. Help needed: Setting parameters in parameter queries

4. putting parameters in one parameter....help!!

5. change a configuration parameter without starting the server

6. starting an access parameter query from VB5 ??

7. Starting an Oracle 6 Db under Windows 95 -- EMM386 parameters

8. need starting SGA parameters

9. undocumented parameter for starting Informix

10. Foxpro 2.6 Debugger, Starting with Command Line Parameters

11. CONNECT BY PRIOR... START WITH

12. SQL Server starting & connecting issues


 
Powered by phpBB® Forum Software