Recursive function in PL/SQL
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Recursive function in PL/SQL

Hybrid View

  1. #1
    Join Date
    Jul 2003
    Posts
    53

    Recursive function in PL/SQL



    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
    anu

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Take a look at hierarchical queries, in particular the CONNECT BY clause

    http://tahiti.oracle.com/pls/db92/db....htm%232076026

    HTH
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width