DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Recursive function in PL/SQL

  1. 08-20-2003, 04:15 AM #1
    anupamasuresh
    anupamasuresh is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 08-20-2003, 04:26 AM #2
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    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!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width