Home » SQL & PL/SQL » SQL & PL/SQL » stored procedure(oracle) that can fetch Hierarchical data from a table
stored procedure(oracle) that can fetch Hierarchical data from a table [message #255177] Mon, 30 July 2007 23:36 Go to next message
ranu2006
Messages: 2
Registered: July 2007
Junior Member
Hi All,

I want to write a stored procedure(oracle) that can fetch Hierarchical data from a table

I will be passing Employee Name and I want to fetch his seniors employees and his junior employees

Tried with Connect by but didn get expected result .

Can any one help in this regard .

M new to stored procedure and Oracle

Thanks in advance.
Re: stored procedure(oracle) that can fetch Hierarchical data from a table [message #255182 is a reply to message #255177] Mon, 30 July 2007 23:42 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
You should NOT use PL/SQL when SQL will suffice.

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:11452690446345
Re: stored procedure(oracle) that can fetch Hierarchical data from a table [message #255214 is a reply to message #255177] Tue, 31 July 2007 00:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read and follow How to format your posts and How to get a quick answer to your question: TIPS AND TRICKS
Make sure that lines of code do not exceed 80 or 100 characters when you format.
Please always post your Oracle version (4 decimals).

Post what you already tried and why it does not fit your requirement.

Regards
Michel
Re: stored procedure(oracle) that can fetch Hierarchical data from a table [message #255444 is a reply to message #255177] Tue, 31 July 2007 23:10 Go to previous message
ranu2006
Messages: 2
Registered: July 2007
Junior Member
Thanks for the advice .
Previous Topic: ORA-00942
Next Topic: ORA-00917: missing comma
Goto Forum:
  


Current Time: Thu Dec 08 16:43:22 CST 2016

Total time taken to generate the page: 0.07909 seconds