Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Oracle recursive request

Status
Not open for further replies.

Gaelle

Programmer
Jun 20, 2001
62
FR
Hi !

I have a request problem : I don't manage to write what I want...
I have two tables :
MODEL SUB_MODEL
_____ _________
MDL_CODE MDL_CODE_SON
MDL_LABEL MDL_CODE_FATHER

It is recursive on sub_model, where MDL_CODE_SON can be a MDL_CODE_FATHER and son on. I would like to be able, for a given model m in table MODEL, to get all the path
MODEL1/MODEL2/.../MODELN/m
I'm trying to use keywords like sys_connect_by_path(MDL_LABEL, '/'), but I never manage to get the full path.
For example, the very first model of the path misses, since it has no father model.

Can someone help me ?

Thanks so much.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top