Here is a quick example to help you understand how oracle Start With analytical function works. The start with .. connect by clause can be used to select data that has a hierarchical relationship. Usually, it is some sort of parent child relationship like supervisor and an employee.
Let’s assume we have a table called employees. I would like to know employees that directly report to supervisor Id 1122456 –simple, right?
Now I would like to know all employees that report to supervisor Id 1122456 (directly on indirectly).
Notice that with the 1st sql we had 3 rows total while using Start With gave us 4 rows back. If you look at the last row on the 2nd select, you notice that employee 0120033 reports to 0120022 who in return reports to 1122456.
|Required Peoplesoft HRMS Functional Training||PeopleSoft Functional||05/07/2013 - 10:29pm|
|Error while saving Voucher||PeopleSoft Functional||05/02/2013 - 1:55am|
|santosh asking que||PeopleSoft Technical||04/30/2013 - 10:22am|
|How can i implement Email functionality to alerts in peoplesoft.||PeopleSoft Technical||04/30/2013 - 5:01am|