:confused: :confused:
There is an application in which a user has many reporting to him and each of these users have people reporting to them and so on this repeats. So i do need help in coding PL/SQL
PLzz do help me out
Anupama Suresh
Printable View
:confused: :confused:
There is an application in which a user has many reporting to him and each of these users have people reporting to them and so on this repeats. So i do need help in coding PL/SQL
PLzz do help me out
Anupama Suresh
Take a look at hierarchical queries, in particular the CONNECT BY clause
http://tahiti.oracle.com/pls/db92/db....htm%232076026
HTH