Create View hierarchy_versions As
Select 1 version, 'N' primary_hier From dual Union All
Select 2 version, 'Y' primary_hier From dualView created.
Create View emp_hierarchy As
Select employee_id, first_name, last_name, manager_id, 1 version From hr.employees Union All
Select employee_id, first_name, last_name, manager_id, 2 version From hr.employeesView created.
Select level, first_name, last_name
From emp_hierarchy h,
hierarchy_versions v
Where h.version = v.version
And v.primary_hier = 'Y'
Start With h.employee_id = 100
Connect By Prior h.employee_id = h.manager_id| LEVEL | FIRST_NAME | LAST_NAME | 4 | Daniel | Faviet | 4 | John | Chen | 4 | Ismael | Sciarra | 4 | Jose Manuel | Urman | 4 | Luis | Popp | 3 | Nancy | Greenberg | 4 | Daniel | Faviet | 4 | John | Chen | 4 | Ismael | Sciarra | 4 | Jose Manuel | Urman | 4 | Luis | Popp | 3 | Jennifer | Whalen | 3 | Susan | Mavris | 3 | Hermann | Baer | 4 | William | Gietz | 3 | Shelley | Higgins | 4 | William | Gietz | 2 | Neena | Kochhar | 4 | Daniel | Faviet | 4 | John | Chen | 4 | Ismael | Sciarra | 4 | Jose Manuel | Urman | 4 | Luis | Popp | 3 | Nancy | Greenberg | 4 | Daniel | Faviet | 4 | John | Chen | 4 | Ismael | Sciarra | 4 | Jose Manuel | Urman | 4 | Luis | Popp | 3 | Jennifer | Whalen | 3 | Susan | Mavris | 3 | Hermann | Baer | 4 | William | Gietz | 3 | Shelley | Higgins | 4 | William | Gietz | 4 | Bruce | Ernst | 4 | David | Austin | 4 | Valli | Pataballa | 4 | Diana | Lorentz | 3 | Alexander | Hunold | 4 | Bruce | Ernst | 4 | David | Austin | 4 | Valli | Pataballa | 4 | Diana | Lorentz | 2 | Lex | De Haan | 4 | Bruce | Ernst | 4 | David | Austin | 4 | Valli | Pataballa | 4 | Diana | Lorentz | 3 | Alexander | Hunold | 4 | Bruce | Ernst | 4 | David | Austin | 4 | Valli | Pataballa | 4 | Diana | Lorentz | 3 | Alexander | Khoo | 3 | Shelli | Baida | 3 | Sigal | Tobias | 3 | Guy | Himuro | 3 | Karen | Colmenares | 2 | Den | Raphaely | 3 | Alexander | Khoo | 3 | Shelli | Baida | 3 | Sigal | Tobias | 3 | Guy | Himuro | 3 | Karen | Colmenares | 3 | Julia | Nayer | 3 | Irene | Mikkilineni | 3 | James | Landry | 3 | Steven | Markle | 3 | Winston | Taylor | 3 | Jean | Fleaur | 3 | Martha | Sullivan | 3 | Girard | Geoni | 2 | Matthew | Weiss | 3 | Julia | Nayer | 3 | Irene | Mikkilineni | 3 | James | Landry | 3 | Steven | Markle | 3 | Winston | Taylor | 3 | Jean | Fleaur | 3 | Martha | Sullivan | 3 | Girard | Geoni | 3 | Laura | Bissot | 3 | Mozhe | Atkinson | 3 | James | Marlow | 3 | TJ | Olson | 3 | Nandita | Sarchand | 3 | Alexis | Bull | 3 | Julia | Dellinger | 3 | Anthony | Cabrio | 2 | Adam | Fripp | 3 | Laura | Bissot | 3 | Mozhe | Atkinson | 3 | James | Marlow | 3 | TJ | Olson | 3 | Nandita | Sarchand | 3 | Alexis | Bull | 3 | Julia | Dellinger | 3 | Anthony | Cabrio | 3 | Jason | Mallin | 3 | Michael | Rogers | 3 | Ki | Gee | 3 | Hazel | Philtanker | 3 | Kelly | Chung | 3 | Jennifer | Dilly | 3 | Timothy | Gates | 3 | Randall | Perkins | 2 | Payam | Kaufling | 3 | Jason | Mallin | 3 | Michael | Rogers | 3 | Ki | Gee | 3 | Hazel | Philtanker | 3 | Kelly | Chung | 3 | Jennifer | Dilly | 3 | Timothy | Gates | 3 | Randall | Perkins | 3 | Renske | Ladwig | 3 | Stephen | Stiles | 3 | John | Seo | 3 | Joshua | Patel | 3 | Sarah | Bell | 3 | Britney | Everett | 3 | Samuel | McCain | 3 | Vance | Jones | 2 | Shanta | Vollman | 3 | Renske | Ladwig | 3 | Stephen | Stiles | 3 | John | Seo | 3 | Joshua | Patel | 3 | Sarah | Bell | 3 | Britney | Everett | 3 | Samuel | McCain | 3 | Vance | Jones | 3 | Trenna | Rajs | 3 | Curtis | Davies | 3 | Randall | Matos | 3 | Peter | Vargas | 3 | Alana | Walsh | 3 | Kevin | Feeney | 3 | Donald | OConnell | 3 | Douglas | Grant | 2 | Kevin | Mourgos | 3 | Trenna | Rajs | 3 | Curtis | Davies | 3 | Randall | Matos | 3 | Peter | Vargas | 3 | Alana | Walsh | 3 | Kevin | Feeney | 3 | Donald | OConnell | 3 | Douglas | Grant | 3 | Peter | Tucker | 3 | David | Bernstein | 3 | Peter | Hall | 3 | Christopher | Olsen | 3 | Nanette | Cambrault | 3 | Oliver | Tuvault | 2 | John | Russell | 3 | Peter | Tucker | 3 | David | Bernstein | 3 | Peter | Hall | 3 | Christopher | Olsen | 3 | Nanette | Cambrault | 3 | Oliver | Tuvault | 3 | Janette | King | 3 | Patrick | Sully | 3 | Allan | McEwen | 3 | Lindsey | Smith | 3 | Louise | Doran | 3 | Sarath | Sewall | 2 | Karen | Partners | 3 | Janette | King | 3 | Patrick | Sully | 3 | Allan | McEwen | 3 | Lindsey | Smith | 3 | Louise | Doran | 3 | Sarath | Sewall | 3 | Clara | Vishney | 3 | Danielle | Greene | 3 | Mattea | Marvins | 3 | David | Lee | 3 | Sundar | Ande | 3 | Amit | Banda | 2 | Alberto | Errazuriz | 3 | Clara | Vishney | 3 | Danielle | Greene | 3 | Mattea | Marvins | 3 | David | Lee | 3 | Sundar | Ande | 3 | Amit | Banda | 3 | Lisa | Ozer | 3 | Harrison | Bloom | 3 | Tayler | Fox | 3 | William | Smith | 3 | Elizabeth | Bates | 3 | Sundita | Kumar | 2 | Gerald | Cambrault | 3 | Lisa | Ozer | 3 | Harrison | Bloom | 3 | Tayler | Fox | 3 | William | Smith | 3 | Elizabeth | Bates | 3 | Sundita | Kumar | 3 | Ellen | Abel | 3 | Alyssa | Hutton | 3 | Jonathon | Taylor | 3 | Jack | Livingston | 3 | Kimberely | Grant | 3 | Charles | Johnson | 2 | Eleni | Zlotkey | 3 | Ellen | Abel | 3 | Alyssa | Hutton | 3 | Jonathon | Taylor | 3 | Jack | Livingston | 3 | Kimberely | Grant | 3 | Charles | Johnson | 3 | Pat | Fay | 2 | Michael | Hartstein | 3 | Pat | Fay | 1 | Steven | King | 4 | Daniel | Faviet | 4 | John | Chen | 4 | Ismael | Sciarra | 4 | Jose Manuel | Urman | 4 | Luis | Popp | 3 | Nancy | Greenberg | 4 | Daniel | Faviet | 4 | John | Chen | 4 | Ismael | Sciarra | 4 | Jose Manuel | Urman | 4 | Luis | Popp | 3 | Jennifer | Whalen | 3 | Susan | Mavris | 3 | Hermann | Baer | 4 | William | Gietz | 3 | Shelley | Higgins | 4 | William | Gietz | 2 | Neena | Kochhar | 4 | Daniel | Faviet | 4 | John | Chen | 4 | Ismael | Sciarra | 4 | Jose Manuel | Urman | 4 | Luis | Popp | 3 | Nancy | Greenberg | 4 | Daniel | Faviet | 4 | John | Chen | 4 | Ismael | Sciarra | 4 | Jose Manuel | Urman | 4 | Luis | Popp | 3 | Jennifer | Whalen | 3 | Susan | Mavris | 3 | Hermann | Baer | 4 | William | Gietz | 3 | Shelley | Higgins | 4 | William | Gietz | 4 | Bruce | Ernst | 4 | David | Austin | 4 | Valli | Pataballa | 4 | Diana | Lorentz | 3 | Alexander | Hunold | 4 | Bruce | Ernst | 4 | David | Austin | 4 | Valli | Pataballa | 4 | Diana | Lorentz | 2 | Lex | De Haan | 4 | Bruce | Ernst | 4 | David | Austin | 4 | Valli | Pataballa | 4 | Diana | Lorentz | 3 | Alexander | Hunold | 4 | Bruce | Ernst | 4 | David | Austin | 4 | Valli | Pataballa | 4 | Diana | Lorentz | 3 | Alexander | Khoo | 3 | Shelli | Baida | 3 | Sigal | Tobias | 3 | Guy | Himuro | 3 | Karen | Colmenares | 2 | Den | Raphaely | 3 | Alexander | Khoo | 3 | Shelli | Baida | 3 | Sigal | Tobias | 3 | Guy | Himuro | 3 | Karen | Colmenares | 3 | Julia | Nayer | 3 | Irene | Mikkilineni | 3 | James | Landry | 3 | Steven | Markle | 3 | Winston | Taylor | 3 | Jean | Fleaur | 3 | Martha | Sullivan | 3 | Girard | Geoni | 2 | Matthew | Weiss | 3 | Julia | Nayer | 3 | Irene | Mikkilineni | 3 | James | Landry | 3 | Steven | Markle | 3 | Winston | Taylor | 3 | Jean | Fleaur | 3 | Martha | Sullivan | 3 | Girard | Geoni | 3 | Laura | Bissot | 3 | Mozhe | Atkinson | 3 | James | Marlow | 3 | TJ | Olson | 3 | Nandita | Sarchand | 3 | Alexis | Bull | 3 | Julia | Dellinger | 3 | Anthony | Cabrio | 2 | Adam | Fripp | 3 | Laura | Bissot | 3 | Mozhe | Atkinson | 3 | James | Marlow | 3 | TJ | Olson | 3 | Nandita | Sarchand | 3 | Alexis | Bull | 3 | Julia | Dellinger | 3 | Anthony | Cabrio | 3 | Jason | Mallin | 3 | Michael | Rogers | 3 | Ki | Gee | 3 | Hazel | Philtanker | 3 | Kelly | Chung | 3 | Jennifer | Dilly | 3 | Timothy | Gates | 3 | Randall | Perkins | 2 | Payam | Kaufling | 3 | Jason | Mallin | 3 | Michael | Rogers | 3 | Ki | Gee | 3 | Hazel | Philtanker | 3 | Kelly | Chung | 3 | Jennifer | Dilly | 3 | Timothy | Gates | 3 | Randall | Perkins | 3 | Renske | Ladwig | 3 | Stephen | Stiles | 3 | John | Seo | 3 | Joshua | Patel | 3 | Sarah | Bell | 3 | Britney | Everett | 3 | Samuel | McCain | 3 | Vance | Jones | 2 | Shanta | Vollman | 3 | Renske | Ladwig | 3 | Stephen | Stiles | 3 | John | Seo | 3 | Joshua | Patel | 3 | Sarah | Bell | 3 | Britney | Everett | 3 | Samuel | McCain | 3 | Vance | Jones | 3 | Trenna | Rajs | 3 | Curtis | Davies | 3 | Randall | Matos | 3 | Peter | Vargas | 3 | Alana | Walsh | 3 | Kevin | Feeney | 3 | Donald | OConnell | 3 | Douglas | Grant | 2 | Kevin | Mourgos | 3 | Trenna | Rajs | 3 | Curtis | Davies | 3 | Randall | Matos | 3 | Peter | Vargas | 3 | Alana | Walsh | 3 | Kevin | Feeney | 3 | Donald | OConnell | 3 | Douglas | Grant | 3 | Peter | Tucker | 3 | David | Bernstein | 3 | Peter | Hall | 3 | Christopher | Olsen | 3 | Nanette | Cambrault | 3 | Oliver | Tuvault | 2 | John | Russell | 3 | Peter | Tucker | 3 | David | Bernstein | 3 | Peter | Hall | 3 | Christopher | Olsen | 3 | Nanette | Cambrault | 3 | Oliver | Tuvault | 3 | Janette | King | 3 | Patrick | Sully | 3 | Allan | McEwen | 3 | Lindsey | Smith | 3 | Louise | Doran | 3 | Sarath | Sewall | 2 | Karen | Partners | 3 | Janette | King | 3 | Patrick | Sully | 3 | Allan | McEwen | 3 | Lindsey | Smith | 3 | Louise | Doran | 3 | Sarath | Sewall | 3 | Clara | Vishney | 3 | Danielle | Greene | 3 | Mattea | Marvins | 3 | David | Lee | 3 | Sundar | Ande | 3 | Amit | Banda | 2 | Alberto | Errazuriz | 3 | Clara | Vishney | 3 | Danielle | Greene | 3 | Mattea | Marvins | 3 | David | Lee | 3 | Sundar | Ande | 3 | Amit | Banda | 3 | Lisa | Ozer | 3 | Harrison | Bloom | 3 | Tayler | Fox | 3 | William | Smith | 3 | Elizabeth | Bates | 3 | Sundita | Kumar | 2 | Gerald | Cambrault | 3 | Lisa | Ozer | 3 | Harrison | Bloom | 3 | Tayler | Fox | 3 | William | Smith | 3 | Elizabeth | Bates | 3 | Sundita | Kumar | 3 | Ellen | Abel | 3 | Alyssa | Hutton | 3 | Jonathon | Taylor | 3 | Jack | Livingston | 3 | Kimberely | Grant | 3 | Charles | Johnson | 2 | Eleni | Zlotkey | 3 | Ellen | Abel | 3 | Alyssa | Hutton | 3 | Jonathon | Taylor | 3 | Jack | Livingston | 3 | Kimberely | Grant | 3 | Charles | Johnson | 3 | Pat | Fay | 2 | Michael | Hartstein | 3 | Pat | Fay |
|---|
Select level, first_name, last_name
From emp_hierarchy h,
hierarchy_versions v
Where h.version = v.version
And v.primary_hier = 'Y'
Start With h.employee_id = 100
Connect By Prior h.employee_id = h.manager_id
And Prior h.version = h.version| LEVEL | FIRST_NAME | LAST_NAME | 1 | Steven | King | 2 | Neena | Kochhar | 3 | Nancy | Greenberg | 4 | Daniel | Faviet | 4 | John | Chen | 4 | Ismael | Sciarra | 4 | Jose Manuel | Urman | 4 | Luis | Popp | 3 | Jennifer | Whalen | 3 | Susan | Mavris | 3 | Hermann | Baer | 3 | Shelley | Higgins | 4 | William | Gietz | 2 | Lex | De Haan | 3 | Alexander | Hunold | 4 | Bruce | Ernst | 4 | David | Austin | 4 | Valli | Pataballa | 4 | Diana | Lorentz | 2 | Den | Raphaely | 3 | Alexander | Khoo | 3 | Shelli | Baida | 3 | Sigal | Tobias | 3 | Guy | Himuro | 3 | Karen | Colmenares | 2 | Matthew | Weiss | 3 | Julia | Nayer | 3 | Irene | Mikkilineni | 3 | James | Landry | 3 | Steven | Markle | 3 | Winston | Taylor | 3 | Jean | Fleaur | 3 | Martha | Sullivan | 3 | Girard | Geoni | 2 | Adam | Fripp | 3 | Laura | Bissot | 3 | Mozhe | Atkinson | 3 | James | Marlow | 3 | TJ | Olson | 3 | Nandita | Sarchand | 3 | Alexis | Bull | 3 | Julia | Dellinger | 3 | Anthony | Cabrio | 2 | Payam | Kaufling | 3 | Jason | Mallin | 3 | Michael | Rogers | 3 | Ki | Gee | 3 | Hazel | Philtanker | 3 | Kelly | Chung | 3 | Jennifer | Dilly | 3 | Timothy | Gates | 3 | Randall | Perkins | 2 | Shanta | Vollman | 3 | Renske | Ladwig | 3 | Stephen | Stiles | 3 | John | Seo | 3 | Joshua | Patel | 3 | Sarah | Bell | 3 | Britney | Everett | 3 | Samuel | McCain | 3 | Vance | Jones | 2 | Kevin | Mourgos | 3 | Trenna | Rajs | 3 | Curtis | Davies | 3 | Randall | Matos | 3 | Peter | Vargas | 3 | Alana | Walsh | 3 | Kevin | Feeney | 3 | Donald | OConnell | 3 | Douglas | Grant | 2 | John | Russell | 3 | Peter | Tucker | 3 | David | Bernstein | 3 | Peter | Hall | 3 | Christopher | Olsen | 3 | Nanette | Cambrault | 3 | Oliver | Tuvault | 2 | Karen | Partners | 3 | Janette | King | 3 | Patrick | Sully | 3 | Allan | McEwen | 3 | Lindsey | Smith | 3 | Louise | Doran | 3 | Sarath | Sewall | 2 | Alberto | Errazuriz | 3 | Clara | Vishney | 3 | Danielle | Greene | 3 | Mattea | Marvins | 3 | David | Lee | 3 | Sundar | Ande | 3 | Amit | Banda | 2 | Gerald | Cambrault | 3 | Lisa | Ozer | 3 | Harrison | Bloom | 3 | Tayler | Fox | 3 | William | Smith | 3 | Elizabeth | Bates | 3 | Sundita | Kumar | 2 | Eleni | Zlotkey | 3 | Ellen | Abel | 3 | Alyssa | Hutton | 3 | Jonathon | Taylor | 3 | Jack | Livingston | 3 | Kimberely | Grant | 3 | Charles | Johnson | 2 | Michael | Hartstein | 3 | Pat | Fay |
|---|
Select level, n.first_name, n.last_name
From emp_hierarchy h,
hierarchy_versions v,
emp_names n
Where h.version = v.version
And n.employee_id = h.employee_id
And v.primary_hier = 'Y'
Start With h.employee_id = 100
Connect By Prior h.employee_id = h.manager_id
And Prior h.version = h.versionORA-00942: table or view does not existMore Details: https://docs.oracle.com/error-help/db/ora-00942
Create View emp_names As
Select employee_id, first_name, last_name From hr.employeesView created.
Select level, n.first_name, n.last_name
From emp_hierarchy h,
hierarchy_versions v,
emp_names n
Where h.version = v.version
And n.employee_id = h.employee_id
And v.primary_hier = 'Y'
Start With h.employee_id = 100
Connect By Prior h.employee_id = h.manager_id
And Prior h.version = h.version| LEVEL | FIRST_NAME | LAST_NAME | 1 | Steven | King | 2 | Neena | Kochhar | 3 | Nancy | Greenberg | 4 | Daniel | Faviet | 4 | John | Chen | 4 | Ismael | Sciarra | 4 | Jose Manuel | Urman | 4 | Luis | Popp | 3 | Jennifer | Whalen | 3 | Susan | Mavris | 3 | Hermann | Baer | 3 | Shelley | Higgins | 4 | William | Gietz | 2 | Lex | De Haan | 3 | Alexander | Hunold | 4 | Bruce | Ernst | 4 | David | Austin | 4 | Valli | Pataballa | 4 | Diana | Lorentz | 2 | Den | Raphaely | 3 | Alexander | Khoo | 3 | Shelli | Baida | 3 | Sigal | Tobias | 3 | Guy | Himuro | 3 | Karen | Colmenares | 2 | Matthew | Weiss | 3 | Julia | Nayer | 3 | Irene | Mikkilineni | 3 | James | Landry | 3 | Steven | Markle | 3 | Winston | Taylor | 3 | Jean | Fleaur | 3 | Martha | Sullivan | 3 | Girard | Geoni | 2 | Adam | Fripp | 3 | Laura | Bissot | 3 | Mozhe | Atkinson | 3 | James | Marlow | 3 | TJ | Olson | 3 | Nandita | Sarchand | 3 | Alexis | Bull | 3 | Julia | Dellinger | 3 | Anthony | Cabrio | 2 | Payam | Kaufling | 3 | Jason | Mallin | 3 | Michael | Rogers | 3 | Ki | Gee | 3 | Hazel | Philtanker | 3 | Kelly | Chung | 3 | Jennifer | Dilly | 3 | Timothy | Gates | 3 | Randall | Perkins | 2 | Shanta | Vollman | 3 | Renske | Ladwig | 3 | Stephen | Stiles | 3 | John | Seo | 3 | Joshua | Patel | 3 | Sarah | Bell | 3 | Britney | Everett | 3 | Samuel | McCain | 3 | Vance | Jones | 2 | Kevin | Mourgos | 3 | Trenna | Rajs | 3 | Curtis | Davies | 3 | Randall | Matos | 3 | Peter | Vargas | 3 | Alana | Walsh | 3 | Kevin | Feeney | 3 | Donald | OConnell | 3 | Douglas | Grant | 2 | John | Russell | 3 | Peter | Tucker | 3 | David | Bernstein | 3 | Peter | Hall | 3 | Christopher | Olsen | 3 | Nanette | Cambrault | 3 | Oliver | Tuvault | 2 | Karen | Partners | 3 | Janette | King | 3 | Patrick | Sully | 3 | Allan | McEwen | 3 | Lindsey | Smith | 3 | Louise | Doran | 3 | Sarath | Sewall | 2 | Alberto | Errazuriz | 3 | Clara | Vishney | 3 | Danielle | Greene | 3 | Mattea | Marvins | 3 | David | Lee | 3 | Sundar | Ande | 3 | Amit | Banda | 2 | Gerald | Cambrault | 3 | Lisa | Ozer | 3 | Harrison | Bloom | 3 | Tayler | Fox | 3 | William | Smith | 3 | Elizabeth | Bates | 3 | Sundita | Kumar | 2 | Eleni | Zlotkey | 3 | Ellen | Abel | 3 | Alyssa | Hutton | 3 | Jonathon | Taylor | 3 | Jack | Livingston | 3 | Kimberely | Grant | 3 | Charles | Johnson | 2 | Michael | Hartstein | 3 | Pat | Fay |
|---|
Create or Replace View emp_names As
Select employee_id, first_name, last_name, 'UK' From hr.employees Union All
Select employee_id, first_name, last_name || 'O', 'SPANISH' From hr.employeesORA-00998: must name this expression with a column aliasMore Details: https://docs.oracle.com/error-help/db/ora-00998
Create or Replace View emp_names As
Select employee_id, first_name, last_name, 'UK' lang From hr.employees Union All
Select employee_id, first_name, last_name || 'O', 'SPANISH' lang From hr.employeesView created.
Select level, n.first_name, n.last_name
From emp_hierarchy h,
hierarchy_versions v,
emp_names n
Where h.version = v.version
And n.employee_id = h.employee_id
And v.primary_hier = 'Y'
And n.lang='SPANISH'
Start With h.employee_id = 100
Connect By Prior h.employee_id = h.manager_id
And Prior h.version = h.version| LEVEL | FIRST_NAME | LAST_NAME | 4 | Daniel | FavietO | 4 | John | ChenO | 4 | Ismael | SciarraO | 4 | Jose Manuel | UrmanO | 4 | Luis | PoppO | 3 | Nancy | GreenbergO | 4 | Daniel | FavietO | 4 | John | ChenO | 4 | Ismael | SciarraO | 4 | Jose Manuel | UrmanO | 4 | Luis | PoppO | 3 | Jennifer | WhalenO | 3 | Susan | MavrisO | 3 | Hermann | BaerO | 4 | William | GietzO | 3 | Shelley | HigginsO | 4 | William | GietzO | 2 | Neena | KochharO | 4 | Daniel | FavietO | 4 | John | ChenO | 4 | Ismael | SciarraO | 4 | Jose Manuel | UrmanO | 4 | Luis | PoppO | 3 | Nancy | GreenbergO | 4 | Daniel | FavietO | 4 | John | ChenO | 4 | Ismael | SciarraO | 4 | Jose Manuel | UrmanO | 4 | Luis | PoppO | 3 | Jennifer | WhalenO | 3 | Susan | MavrisO | 3 | Hermann | BaerO | 4 | William | GietzO | 3 | Shelley | HigginsO | 4 | William | GietzO | 4 | Bruce | ErnstO | 4 | David | AustinO | 4 | Valli | PataballaO | 4 | Diana | LorentzO | 3 | Alexander | HunoldO | 4 | Bruce | ErnstO | 4 | David | AustinO | 4 | Valli | PataballaO | 4 | Diana | LorentzO | 2 | Lex | De HaanO | 4 | Bruce | ErnstO | 4 | David | AustinO | 4 | Valli | PataballaO | 4 | Diana | LorentzO | 3 | Alexander | HunoldO | 4 | Bruce | ErnstO | 4 | David | AustinO | 4 | Valli | PataballaO | 4 | Diana | LorentzO | 3 | Alexander | KhooO | 3 | Shelli | BaidaO | 3 | Sigal | TobiasO | 3 | Guy | HimuroO | 3 | Karen | ColmenaresO | 2 | Den | RaphaelyO | 3 | Alexander | KhooO | 3 | Shelli | BaidaO | 3 | Sigal | TobiasO | 3 | Guy | HimuroO | 3 | Karen | ColmenaresO | 3 | Julia | NayerO | 3 | Irene | MikkilineniO | 3 | James | LandryO | 3 | Steven | MarkleO | 3 | Winston | TaylorO | 3 | Jean | FleaurO | 3 | Martha | SullivanO | 3 | Girard | GeoniO | 2 | Matthew | WeissO | 3 | Julia | NayerO | 3 | Irene | MikkilineniO | 3 | James | LandryO | 3 | Steven | MarkleO | 3 | Winston | TaylorO | 3 | Jean | FleaurO | 3 | Martha | SullivanO | 3 | Girard | GeoniO | 3 | Laura | BissotO | 3 | Mozhe | AtkinsonO | 3 | James | MarlowO | 3 | TJ | OlsonO | 3 | Nandita | SarchandO | 3 | Alexis | BullO | 3 | Julia | DellingerO | 3 | Anthony | CabrioO | 2 | Adam | FrippO | 3 | Laura | BissotO | 3 | Mozhe | AtkinsonO | 3 | James | MarlowO | 3 | TJ | OlsonO | 3 | Nandita | SarchandO | 3 | Alexis | BullO | 3 | Julia | DellingerO | 3 | Anthony | CabrioO | 3 | Jason | MallinO | 3 | Michael | RogersO | 3 | Ki | GeeO | 3 | Hazel | PhiltankerO | 3 | Kelly | ChungO | 3 | Jennifer | DillyO | 3 | Timothy | GatesO | 3 | Randall | PerkinsO | 2 | Payam | KauflingO | 3 | Jason | MallinO | 3 | Michael | RogersO | 3 | Ki | GeeO | 3 | Hazel | PhiltankerO | 3 | Kelly | ChungO | 3 | Jennifer | DillyO | 3 | Timothy | GatesO | 3 | Randall | PerkinsO | 3 | Renske | LadwigO | 3 | Stephen | StilesO | 3 | John | SeoO | 3 | Joshua | PatelO | 3 | Sarah | BellO | 3 | Britney | EverettO | 3 | Samuel | McCainO | 3 | Vance | JonesO | 2 | Shanta | VollmanO | 3 | Renske | LadwigO | 3 | Stephen | StilesO | 3 | John | SeoO | 3 | Joshua | PatelO | 3 | Sarah | BellO | 3 | Britney | EverettO | 3 | Samuel | McCainO | 3 | Vance | JonesO | 3 | Trenna | RajsO | 3 | Curtis | DaviesO | 3 | Randall | MatosO | 3 | Peter | VargasO | 3 | Alana | WalshO | 3 | Kevin | FeeneyO | 3 | Donald | OConnellO | 3 | Douglas | GrantO | 2 | Kevin | MourgosO | 3 | Trenna | RajsO | 3 | Curtis | DaviesO | 3 | Randall | MatosO | 3 | Peter | VargasO | 3 | Alana | WalshO | 3 | Kevin | FeeneyO | 3 | Donald | OConnellO | 3 | Douglas | GrantO | 3 | Peter | TuckerO | 3 | David | BernsteinO | 3 | Peter | HallO | 3 | Christopher | OlsenO | 3 | Nanette | CambraultO | 3 | Oliver | TuvaultO | 2 | John | RussellO | 3 | Peter | TuckerO | 3 | David | BernsteinO | 3 | Peter | HallO | 3 | Christopher | OlsenO | 3 | Nanette | CambraultO | 3 | Oliver | TuvaultO | 3 | Janette | KingO | 3 | Patrick | SullyO | 3 | Allan | McEwenO | 3 | Lindsey | SmithO | 3 | Louise | DoranO | 3 | Sarath | SewallO | 2 | Karen | PartnersO | 3 | Janette | KingO | 3 | Patrick | SullyO | 3 | Allan | McEwenO | 3 | Lindsey | SmithO | 3 | Louise | DoranO | 3 | Sarath | SewallO | 3 | Clara | VishneyO | 3 | Danielle | GreeneO | 3 | Mattea | MarvinsO | 3 | David | LeeO | 3 | Sundar | AndeO | 3 | Amit | BandaO | 2 | Alberto | ErrazurizO | 3 | Clara | VishneyO | 3 | Danielle | GreeneO | 3 | Mattea | MarvinsO | 3 | David | LeeO | 3 | Sundar | AndeO | 3 | Amit | BandaO | 3 | Lisa | OzerO | 3 | Harrison | BloomO | 3 | Tayler | FoxO | 3 | William | SmithO | 3 | Elizabeth | BatesO | 3 | Sundita | KumarO | 2 | Gerald | CambraultO | 3 | Lisa | OzerO | 3 | Harrison | BloomO | 3 | Tayler | FoxO | 3 | William | SmithO | 3 | Elizabeth | BatesO | 3 | Sundita | KumarO | 3 | Ellen | AbelO | 3 | Alyssa | HuttonO | 3 | Jonathon | TaylorO | 3 | Jack | LivingstonO | 3 | Kimberely | GrantO | 3 | Charles | JohnsonO | 2 | Eleni | ZlotkeyO | 3 | Ellen | AbelO | 3 | Alyssa | HuttonO | 3 | Jonathon | TaylorO | 3 | Jack | LivingstonO | 3 | Kimberely | GrantO | 3 | Charles | JohnsonO | 3 | Pat | FayO | 2 | Michael | HartsteinO | 3 | Pat | FayO | 1 | Steven | KingO | 4 | Daniel | FavietO | 4 | John | ChenO | 4 | Ismael | SciarraO | 4 | Jose Manuel | UrmanO | 4 | Luis | PoppO | 3 | Nancy | GreenbergO | 4 | Daniel | FavietO | 4 | John | ChenO | 4 | Ismael | SciarraO | 4 | Jose Manuel | UrmanO | 4 | Luis | PoppO | 3 | Jennifer | WhalenO | 3 | Susan | MavrisO | 3 | Hermann | BaerO | 4 | William | GietzO | 3 | Shelley | HigginsO | 4 | William | GietzO | 2 | Neena | KochharO | 4 | Daniel | FavietO | 4 | John | ChenO | 4 | Ismael | SciarraO | 4 | Jose Manuel | UrmanO | 4 | Luis | PoppO | 3 | Nancy | GreenbergO | 4 | Daniel | FavietO | 4 | John | ChenO | 4 | Ismael | SciarraO | 4 | Jose Manuel | UrmanO | 4 | Luis | PoppO | 3 | Jennifer | WhalenO | 3 | Susan | MavrisO | 3 | Hermann | BaerO | 4 | William | GietzO | 3 | Shelley | HigginsO | 4 | William | GietzO | 4 | Bruce | ErnstO | 4 | David | AustinO | 4 | Valli | PataballaO | 4 | Diana | LorentzO | 3 | Alexander | HunoldO | 4 | Bruce | ErnstO | 4 | David | AustinO | 4 | Valli | PataballaO | 4 | Diana | LorentzO | 2 | Lex | De HaanO | 4 | Bruce | ErnstO | 4 | David | AustinO | 4 | Valli | PataballaO | 4 | Diana | LorentzO | 3 | Alexander | HunoldO | 4 | Bruce | ErnstO | 4 | David | AustinO | 4 | Valli | PataballaO | 4 | Diana | LorentzO | 3 | Alexander | KhooO | 3 | Shelli | BaidaO | 3 | Sigal | TobiasO | 3 | Guy | HimuroO | 3 | Karen | ColmenaresO | 2 | Den | RaphaelyO | 3 | Alexander | KhooO | 3 | Shelli | BaidaO | 3 | Sigal | TobiasO | 3 | Guy | HimuroO | 3 | Karen | ColmenaresO | 3 | Julia | NayerO | 3 | Irene | MikkilineniO | 3 | James | LandryO | 3 | Steven | MarkleO | 3 | Winston | TaylorO | 3 | Jean | FleaurO | 3 | Martha | SullivanO | 3 | Girard | GeoniO | 2 | Matthew | WeissO | 3 | Julia | NayerO | 3 | Irene | MikkilineniO | 3 | James | LandryO | 3 | Steven | MarkleO | 3 | Winston | TaylorO | 3 | Jean | FleaurO | 3 | Martha | SullivanO | 3 | Girard | GeoniO | 3 | Laura | BissotO | 3 | Mozhe | AtkinsonO | 3 | James | MarlowO | 3 | TJ | OlsonO | 3 | Nandita | SarchandO | 3 | Alexis | BullO | 3 | Julia | DellingerO | 3 | Anthony | CabrioO | 2 | Adam | FrippO | 3 | Laura | BissotO | 3 | Mozhe | AtkinsonO | 3 | James | MarlowO | 3 | TJ | OlsonO | 3 | Nandita | SarchandO | 3 | Alexis | BullO | 3 | Julia | DellingerO | 3 | Anthony | CabrioO | 3 | Jason | MallinO | 3 | Michael | RogersO | 3 | Ki | GeeO | 3 | Hazel | PhiltankerO | 3 | Kelly | ChungO | 3 | Jennifer | DillyO | 3 | Timothy | GatesO | 3 | Randall | PerkinsO | 2 | Payam | KauflingO | 3 | Jason | MallinO | 3 | Michael | RogersO | 3 | Ki | GeeO | 3 | Hazel | PhiltankerO | 3 | Kelly | ChungO | 3 | Jennifer | DillyO | 3 | Timothy | GatesO | 3 | Randall | PerkinsO | 3 | Renske | LadwigO | 3 | Stephen | StilesO | 3 | John | SeoO | 3 | Joshua | PatelO | 3 | Sarah | BellO | 3 | Britney | EverettO | 3 | Samuel | McCainO | 3 | Vance | JonesO | 2 | Shanta | VollmanO | 3 | Renske | LadwigO | 3 | Stephen | StilesO | 3 | John | SeoO | 3 | Joshua | PatelO | 3 | Sarah | BellO | 3 | Britney | EverettO | 3 | Samuel | McCainO | 3 | Vance | JonesO | 3 | Trenna | RajsO | 3 | Curtis | DaviesO | 3 | Randall | MatosO | 3 | Peter | VargasO | 3 | Alana | WalshO | 3 | Kevin | FeeneyO | 3 | Donald | OConnellO | 3 | Douglas | GrantO | 2 | Kevin | MourgosO | 3 | Trenna | RajsO | 3 | Curtis | DaviesO | 3 | Randall | MatosO | 3 | Peter | VargasO | 3 | Alana | WalshO | 3 | Kevin | FeeneyO | 3 | Donald | OConnellO | 3 | Douglas | GrantO | 3 | Peter | TuckerO | 3 | David | BernsteinO | 3 | Peter | HallO | 3 | Christopher | OlsenO | 3 | Nanette | CambraultO | 3 | Oliver | TuvaultO | 2 | John | RussellO | 3 | Peter | TuckerO | 3 | David | BernsteinO | 3 | Peter | HallO | 3 | Christopher | OlsenO | 3 | Nanette | CambraultO | 3 | Oliver | TuvaultO | 3 | Janette | KingO | 3 | Patrick | SullyO | 3 | Allan | McEwenO | 3 | Lindsey | SmithO | 3 | Louise | DoranO | 3 | Sarath | SewallO | 2 | Karen | PartnersO | 3 | Janette | KingO | 3 | Patrick | SullyO | 3 | Allan | McEwenO | 3 | Lindsey | SmithO | 3 | Louise | DoranO | 3 | Sarath | SewallO | 3 | Clara | VishneyO | 3 | Danielle | GreeneO | 3 | Mattea | MarvinsO | 3 | David | LeeO | 3 | Sundar | AndeO | 3 | Amit | BandaO | 2 | Alberto | ErrazurizO | 3 | Clara | VishneyO | 3 | Danielle | GreeneO | 3 | Mattea | MarvinsO | 3 | David | LeeO | 3 | Sundar | AndeO | 3 | Amit | BandaO | 3 | Lisa | OzerO | 3 | Harrison | BloomO | 3 | Tayler | FoxO | 3 | William | SmithO | 3 | Elizabeth | BatesO | 3 | Sundita | KumarO | 2 | Gerald | CambraultO | 3 | Lisa | OzerO | 3 | Harrison | BloomO | 3 | Tayler | FoxO | 3 | William | SmithO | 3 | Elizabeth | BatesO | 3 | Sundita | KumarO | 3 | Ellen | AbelO | 3 | Alyssa | HuttonO | 3 | Jonathon | TaylorO | 3 | Jack | LivingstonO | 3 | Kimberely | GrantO | 3 | Charles | JohnsonO | 2 | Eleni | ZlotkeyO | 3 | Ellen | AbelO | 3 | Alyssa | HuttonO | 3 | Jonathon | TaylorO | 3 | Jack | LivingstonO | 3 | Kimberely | GrantO | 3 | Charles | JohnsonO | 3 | Pat | FayO | 2 | Michael | HartsteinO | 3 | Pat | FayO |
|---|
Select level, n.first_name, n.last_name
From emp_hierarchy h,
hierarchy_versions v,
emp_names n
Where h.version = v.version
And n.employee_id = h.employee_id
And v.primary_hier = 'Y'
And n.lang='SPANISH'
Start With h.employee_id = 100
Connect By Prior h.employee_id = h.manager_id
And Prior h.version = h.version
And Prior n.lang=n.lang| LEVEL | FIRST_NAME | LAST_NAME | 1 | Steven | KingO | 2 | Neena | KochharO | 3 | Nancy | GreenbergO | 4 | Daniel | FavietO | 4 | John | ChenO | 4 | Ismael | SciarraO | 4 | Jose Manuel | UrmanO | 4 | Luis | PoppO | 3 | Jennifer | WhalenO | 3 | Susan | MavrisO | 3 | Hermann | BaerO | 3 | Shelley | HigginsO | 4 | William | GietzO | 2 | Lex | De HaanO | 3 | Alexander | HunoldO | 4 | Bruce | ErnstO | 4 | David | AustinO | 4 | Valli | PataballaO | 4 | Diana | LorentzO | 2 | Den | RaphaelyO | 3 | Alexander | KhooO | 3 | Shelli | BaidaO | 3 | Sigal | TobiasO | 3 | Guy | HimuroO | 3 | Karen | ColmenaresO | 2 | Matthew | WeissO | 3 | Julia | NayerO | 3 | Irene | MikkilineniO | 3 | James | LandryO | 3 | Steven | MarkleO | 3 | Winston | TaylorO | 3 | Jean | FleaurO | 3 | Martha | SullivanO | 3 | Girard | GeoniO | 2 | Adam | FrippO | 3 | Laura | BissotO | 3 | Mozhe | AtkinsonO | 3 | James | MarlowO | 3 | TJ | OlsonO | 3 | Nandita | SarchandO | 3 | Alexis | BullO | 3 | Julia | DellingerO | 3 | Anthony | CabrioO | 2 | Payam | KauflingO | 3 | Jason | MallinO | 3 | Michael | RogersO | 3 | Ki | GeeO | 3 | Hazel | PhiltankerO | 3 | Kelly | ChungO | 3 | Jennifer | DillyO | 3 | Timothy | GatesO | 3 | Randall | PerkinsO | 2 | Shanta | VollmanO | 3 | Renske | LadwigO | 3 | Stephen | StilesO | 3 | John | SeoO | 3 | Joshua | PatelO | 3 | Sarah | BellO | 3 | Britney | EverettO | 3 | Samuel | McCainO | 3 | Vance | JonesO | 2 | Kevin | MourgosO | 3 | Trenna | RajsO | 3 | Curtis | DaviesO | 3 | Randall | MatosO | 3 | Peter | VargasO | 3 | Alana | WalshO | 3 | Kevin | FeeneyO | 3 | Donald | OConnellO | 3 | Douglas | GrantO | 2 | John | RussellO | 3 | Peter | TuckerO | 3 | David | BernsteinO | 3 | Peter | HallO | 3 | Christopher | OlsenO | 3 | Nanette | CambraultO | 3 | Oliver | TuvaultO | 2 | Karen | PartnersO | 3 | Janette | KingO | 3 | Patrick | SullyO | 3 | Allan | McEwenO | 3 | Lindsey | SmithO | 3 | Louise | DoranO | 3 | Sarath | SewallO | 2 | Alberto | ErrazurizO | 3 | Clara | VishneyO | 3 | Danielle | GreeneO | 3 | Mattea | MarvinsO | 3 | David | LeeO | 3 | Sundar | AndeO | 3 | Amit | BandaO | 2 | Gerald | CambraultO | 3 | Lisa | OzerO | 3 | Harrison | BloomO | 3 | Tayler | FoxO | 3 | William | SmithO | 3 | Elizabeth | BatesO | 3 | Sundita | KumarO | 2 | Eleni | ZlotkeyO | 3 | Ellen | AbelO | 3 | Alyssa | HuttonO | 3 | Jonathon | TaylorO | 3 | Jack | LivingstonO | 3 | Kimberely | GrantO | 3 | Charles | JohnsonO | 2 | Michael | HartsteinO | 3 | Pat | FayO |
|---|
Create View hierarchy_versions As
Select 1 version, 'N' primary_hier From dual Union All
Select 2 version, 'Y' primary_hier From dualORA-00955: name is already used by an existing objectMore Details: https://docs.oracle.com/error-help/db/ora-00955
Create View emp_hierarchy As
Select employee_id, first_name, last_name, manager_id, 1 version From hr.employees Union All
Select employee_id, first_name, last_name, manager_id, 2 version From hr.employeesORA-00955: name is already used by an existing objectMore Details: https://docs.oracle.com/error-help/db/ora-00955
Select level, first_name, last_name
From emp_hierarchy h,
hierarchy_versions v
Where h.version = v.version
And v.primary_hier = 'Y'
Start With h.employee_id = 100
Connect By Prior h.employee_id = h.manager_id| LEVEL | FIRST_NAME | LAST_NAME | 4 | Daniel | Faviet | 4 | John | Chen | 4 | Ismael | Sciarra | 4 | Jose Manuel | Urman | 4 | Luis | Popp | 3 | Nancy | Greenberg | 4 | Daniel | Faviet | 4 | John | Chen | 4 | Ismael | Sciarra | 4 | Jose Manuel | Urman | 4 | Luis | Popp | 3 | Jennifer | Whalen | 3 | Susan | Mavris | 3 | Hermann | Baer | 4 | William | Gietz | 3 | Shelley | Higgins | 4 | William | Gietz | 2 | Neena | Kochhar | 4 | Daniel | Faviet | 4 | John | Chen | 4 | Ismael | Sciarra | 4 | Jose Manuel | Urman | 4 | Luis | Popp | 3 | Nancy | Greenberg | 4 | Daniel | Faviet | 4 | John | Chen | 4 | Ismael | Sciarra | 4 | Jose Manuel | Urman | 4 | Luis | Popp | 3 | Jennifer | Whalen | 3 | Susan | Mavris | 3 | Hermann | Baer | 4 | William | Gietz | 3 | Shelley | Higgins | 4 | William | Gietz | 4 | Bruce | Ernst | 4 | David | Austin | 4 | Valli | Pataballa | 4 | Diana | Lorentz | 3 | Alexander | Hunold | 4 | Bruce | Ernst | 4 | David | Austin | 4 | Valli | Pataballa | 4 | Diana | Lorentz | 2 | Lex | De Haan | 4 | Bruce | Ernst | 4 | David | Austin | 4 | Valli | Pataballa | 4 | Diana | Lorentz | 3 | Alexander | Hunold | 4 | Bruce | Ernst | 4 | David | Austin | 4 | Valli | Pataballa | 4 | Diana | Lorentz | 3 | Alexander | Khoo | 3 | Shelli | Baida | 3 | Sigal | Tobias | 3 | Guy | Himuro | 3 | Karen | Colmenares | 2 | Den | Raphaely | 3 | Alexander | Khoo | 3 | Shelli | Baida | 3 | Sigal | Tobias | 3 | Guy | Himuro | 3 | Karen | Colmenares | 3 | Julia | Nayer | 3 | Irene | Mikkilineni | 3 | James | Landry | 3 | Steven | Markle | 3 | Winston | Taylor | 3 | Jean | Fleaur | 3 | Martha | Sullivan | 3 | Girard | Geoni | 2 | Matthew | Weiss | 3 | Julia | Nayer | 3 | Irene | Mikkilineni | 3 | James | Landry | 3 | Steven | Markle | 3 | Winston | Taylor | 3 | Jean | Fleaur | 3 | Martha | Sullivan | 3 | Girard | Geoni | 3 | Laura | Bissot | 3 | Mozhe | Atkinson | 3 | James | Marlow | 3 | TJ | Olson | 3 | Nandita | Sarchand | 3 | Alexis | Bull | 3 | Julia | Dellinger | 3 | Anthony | Cabrio | 2 | Adam | Fripp | 3 | Laura | Bissot | 3 | Mozhe | Atkinson | 3 | James | Marlow | 3 | TJ | Olson | 3 | Nandita | Sarchand | 3 | Alexis | Bull | 3 | Julia | Dellinger | 3 | Anthony | Cabrio | 3 | Jason | Mallin | 3 | Michael | Rogers | 3 | Ki | Gee | 3 | Hazel | Philtanker | 3 | Kelly | Chung | 3 | Jennifer | Dilly | 3 | Timothy | Gates | 3 | Randall | Perkins | 2 | Payam | Kaufling | 3 | Jason | Mallin | 3 | Michael | Rogers | 3 | Ki | Gee | 3 | Hazel | Philtanker | 3 | Kelly | Chung | 3 | Jennifer | Dilly | 3 | Timothy | Gates | 3 | Randall | Perkins | 3 | Renske | Ladwig | 3 | Stephen | Stiles | 3 | John | Seo | 3 | Joshua | Patel | 3 | Sarah | Bell | 3 | Britney | Everett | 3 | Samuel | McCain | 3 | Vance | Jones | 2 | Shanta | Vollman | 3 | Renske | Ladwig | 3 | Stephen | Stiles | 3 | John | Seo | 3 | Joshua | Patel | 3 | Sarah | Bell | 3 | Britney | Everett | 3 | Samuel | McCain | 3 | Vance | Jones | 3 | Trenna | Rajs | 3 | Curtis | Davies | 3 | Randall | Matos | 3 | Peter | Vargas | 3 | Alana | Walsh | 3 | Kevin | Feeney | 3 | Donald | OConnell | 3 | Douglas | Grant | 2 | Kevin | Mourgos | 3 | Trenna | Rajs | 3 | Curtis | Davies | 3 | Randall | Matos | 3 | Peter | Vargas | 3 | Alana | Walsh | 3 | Kevin | Feeney | 3 | Donald | OConnell | 3 | Douglas | Grant | 3 | Peter | Tucker | 3 | David | Bernstein | 3 | Peter | Hall | 3 | Christopher | Olsen | 3 | Nanette | Cambrault | 3 | Oliver | Tuvault | 2 | John | Russell | 3 | Peter | Tucker | 3 | David | Bernstein | 3 | Peter | Hall | 3 | Christopher | Olsen | 3 | Nanette | Cambrault | 3 | Oliver | Tuvault | 3 | Janette | King | 3 | Patrick | Sully | 3 | Allan | McEwen | 3 | Lindsey | Smith | 3 | Louise | Doran | 3 | Sarath | Sewall | 2 | Karen | Partners | 3 | Janette | King | 3 | Patrick | Sully | 3 | Allan | McEwen | 3 | Lindsey | Smith | 3 | Louise | Doran | 3 | Sarath | Sewall | 3 | Clara | Vishney | 3 | Danielle | Greene | 3 | Mattea | Marvins | 3 | David | Lee | 3 | Sundar | Ande | 3 | Amit | Banda | 2 | Alberto | Errazuriz | 3 | Clara | Vishney | 3 | Danielle | Greene | 3 | Mattea | Marvins | 3 | David | Lee | 3 | Sundar | Ande | 3 | Amit | Banda | 3 | Lisa | Ozer | 3 | Harrison | Bloom | 3 | Tayler | Fox | 3 | William | Smith | 3 | Elizabeth | Bates | 3 | Sundita | Kumar | 2 | Gerald | Cambrault | 3 | Lisa | Ozer | 3 | Harrison | Bloom | 3 | Tayler | Fox | 3 | William | Smith | 3 | Elizabeth | Bates | 3 | Sundita | Kumar | 3 | Ellen | Abel | 3 | Alyssa | Hutton | 3 | Jonathon | Taylor | 3 | Jack | Livingston | 3 | Kimberely | Grant | 3 | Charles | Johnson | 2 | Eleni | Zlotkey | 3 | Ellen | Abel | 3 | Alyssa | Hutton | 3 | Jonathon | Taylor | 3 | Jack | Livingston | 3 | Kimberely | Grant | 3 | Charles | Johnson | 3 | Pat | Fay | 2 | Michael | Hartstein | 3 | Pat | Fay | 1 | Steven | King | 4 | Daniel | Faviet | 4 | John | Chen | 4 | Ismael | Sciarra | 4 | Jose Manuel | Urman | 4 | Luis | Popp | 3 | Nancy | Greenberg | 4 | Daniel | Faviet | 4 | John | Chen | 4 | Ismael | Sciarra | 4 | Jose Manuel | Urman | 4 | Luis | Popp | 3 | Jennifer | Whalen | 3 | Susan | Mavris | 3 | Hermann | Baer | 4 | William | Gietz | 3 | Shelley | Higgins | 4 | William | Gietz | 2 | Neena | Kochhar | 4 | Daniel | Faviet | 4 | John | Chen | 4 | Ismael | Sciarra | 4 | Jose Manuel | Urman | 4 | Luis | Popp | 3 | Nancy | Greenberg | 4 | Daniel | Faviet | 4 | John | Chen | 4 | Ismael | Sciarra | 4 | Jose Manuel | Urman | 4 | Luis | Popp | 3 | Jennifer | Whalen | 3 | Susan | Mavris | 3 | Hermann | Baer | 4 | William | Gietz | 3 | Shelley | Higgins | 4 | William | Gietz | 4 | Bruce | Ernst | 4 | David | Austin | 4 | Valli | Pataballa | 4 | Diana | Lorentz | 3 | Alexander | Hunold | 4 | Bruce | Ernst | 4 | David | Austin | 4 | Valli | Pataballa | 4 | Diana | Lorentz | 2 | Lex | De Haan | 4 | Bruce | Ernst | 4 | David | Austin | 4 | Valli | Pataballa | 4 | Diana | Lorentz | 3 | Alexander | Hunold | 4 | Bruce | Ernst | 4 | David | Austin | 4 | Valli | Pataballa | 4 | Diana | Lorentz | 3 | Alexander | Khoo | 3 | Shelli | Baida | 3 | Sigal | Tobias | 3 | Guy | Himuro | 3 | Karen | Colmenares | 2 | Den | Raphaely | 3 | Alexander | Khoo | 3 | Shelli | Baida | 3 | Sigal | Tobias | 3 | Guy | Himuro | 3 | Karen | Colmenares | 3 | Julia | Nayer | 3 | Irene | Mikkilineni | 3 | James | Landry | 3 | Steven | Markle | 3 | Winston | Taylor | 3 | Jean | Fleaur | 3 | Martha | Sullivan | 3 | Girard | Geoni | 2 | Matthew | Weiss | 3 | Julia | Nayer | 3 | Irene | Mikkilineni | 3 | James | Landry | 3 | Steven | Markle | 3 | Winston | Taylor | 3 | Jean | Fleaur | 3 | Martha | Sullivan | 3 | Girard | Geoni | 3 | Laura | Bissot | 3 | Mozhe | Atkinson | 3 | James | Marlow | 3 | TJ | Olson | 3 | Nandita | Sarchand | 3 | Alexis | Bull | 3 | Julia | Dellinger | 3 | Anthony | Cabrio | 2 | Adam | Fripp | 3 | Laura | Bissot | 3 | Mozhe | Atkinson | 3 | James | Marlow | 3 | TJ | Olson | 3 | Nandita | Sarchand | 3 | Alexis | Bull | 3 | Julia | Dellinger | 3 | Anthony | Cabrio | 3 | Jason | Mallin | 3 | Michael | Rogers | 3 | Ki | Gee | 3 | Hazel | Philtanker | 3 | Kelly | Chung | 3 | Jennifer | Dilly | 3 | Timothy | Gates | 3 | Randall | Perkins | 2 | Payam | Kaufling | 3 | Jason | Mallin | 3 | Michael | Rogers | 3 | Ki | Gee | 3 | Hazel | Philtanker | 3 | Kelly | Chung | 3 | Jennifer | Dilly | 3 | Timothy | Gates | 3 | Randall | Perkins | 3 | Renske | Ladwig | 3 | Stephen | Stiles | 3 | John | Seo | 3 | Joshua | Patel | 3 | Sarah | Bell | 3 | Britney | Everett | 3 | Samuel | McCain | 3 | Vance | Jones | 2 | Shanta | Vollman | 3 | Renske | Ladwig | 3 | Stephen | Stiles | 3 | John | Seo | 3 | Joshua | Patel | 3 | Sarah | Bell | 3 | Britney | Everett | 3 | Samuel | McCain | 3 | Vance | Jones | 3 | Trenna | Rajs | 3 | Curtis | Davies | 3 | Randall | Matos | 3 | Peter | Vargas | 3 | Alana | Walsh | 3 | Kevin | Feeney | 3 | Donald | OConnell | 3 | Douglas | Grant | 2 | Kevin | Mourgos | 3 | Trenna | Rajs | 3 | Curtis | Davies | 3 | Randall | Matos | 3 | Peter | Vargas | 3 | Alana | Walsh | 3 | Kevin | Feeney | 3 | Donald | OConnell | 3 | Douglas | Grant | 3 | Peter | Tucker | 3 | David | Bernstein | 3 | Peter | Hall | 3 | Christopher | Olsen | 3 | Nanette | Cambrault | 3 | Oliver | Tuvault | 2 | John | Russell | 3 | Peter | Tucker | 3 | David | Bernstein | 3 | Peter | Hall | 3 | Christopher | Olsen | 3 | Nanette | Cambrault | 3 | Oliver | Tuvault | 3 | Janette | King | 3 | Patrick | Sully | 3 | Allan | McEwen | 3 | Lindsey | Smith | 3 | Louise | Doran | 3 | Sarath | Sewall | 2 | Karen | Partners | 3 | Janette | King | 3 | Patrick | Sully | 3 | Allan | McEwen | 3 | Lindsey | Smith | 3 | Louise | Doran | 3 | Sarath | Sewall | 3 | Clara | Vishney | 3 | Danielle | Greene | 3 | Mattea | Marvins | 3 | David | Lee | 3 | Sundar | Ande | 3 | Amit | Banda | 2 | Alberto | Errazuriz | 3 | Clara | Vishney | 3 | Danielle | Greene | 3 | Mattea | Marvins | 3 | David | Lee | 3 | Sundar | Ande | 3 | Amit | Banda | 3 | Lisa | Ozer | 3 | Harrison | Bloom | 3 | Tayler | Fox | 3 | William | Smith | 3 | Elizabeth | Bates | 3 | Sundita | Kumar | 2 | Gerald | Cambrault | 3 | Lisa | Ozer | 3 | Harrison | Bloom | 3 | Tayler | Fox | 3 | William | Smith | 3 | Elizabeth | Bates | 3 | Sundita | Kumar | 3 | Ellen | Abel | 3 | Alyssa | Hutton | 3 | Jonathon | Taylor | 3 | Jack | Livingston | 3 | Kimberely | Grant | 3 | Charles | Johnson | 2 | Eleni | Zlotkey | 3 | Ellen | Abel | 3 | Alyssa | Hutton | 3 | Jonathon | Taylor | 3 | Jack | Livingston | 3 | Kimberely | Grant | 3 | Charles | Johnson | 3 | Pat | Fay | 2 | Michael | Hartstein | 3 | Pat | Fay |
|---|
Select level, first_name, last_name
From emp_hierarchy h,
hierarchy_versions v
Where h.version = v.version
And v.primary_hier = 'Y'
Start With h.employee_id = 100
Connect By Prior h.employee_id = h.manager_id
And Prior h.version = h.version| LEVEL | FIRST_NAME | LAST_NAME | 1 | Steven | King | 2 | Neena | Kochhar | 3 | Nancy | Greenberg | 4 | Daniel | Faviet | 4 | John | Chen | 4 | Ismael | Sciarra | 4 | Jose Manuel | Urman | 4 | Luis | Popp | 3 | Jennifer | Whalen | 3 | Susan | Mavris | 3 | Hermann | Baer | 3 | Shelley | Higgins | 4 | William | Gietz | 2 | Lex | De Haan | 3 | Alexander | Hunold | 4 | Bruce | Ernst | 4 | David | Austin | 4 | Valli | Pataballa | 4 | Diana | Lorentz | 2 | Den | Raphaely | 3 | Alexander | Khoo | 3 | Shelli | Baida | 3 | Sigal | Tobias | 3 | Guy | Himuro | 3 | Karen | Colmenares | 2 | Matthew | Weiss | 3 | Julia | Nayer | 3 | Irene | Mikkilineni | 3 | James | Landry | 3 | Steven | Markle | 3 | Winston | Taylor | 3 | Jean | Fleaur | 3 | Martha | Sullivan | 3 | Girard | Geoni | 2 | Adam | Fripp | 3 | Laura | Bissot | 3 | Mozhe | Atkinson | 3 | James | Marlow | 3 | TJ | Olson | 3 | Nandita | Sarchand | 3 | Alexis | Bull | 3 | Julia | Dellinger | 3 | Anthony | Cabrio | 2 | Payam | Kaufling | 3 | Jason | Mallin | 3 | Michael | Rogers | 3 | Ki | Gee | 3 | Hazel | Philtanker | 3 | Kelly | Chung | 3 | Jennifer | Dilly | 3 | Timothy | Gates | 3 | Randall | Perkins | 2 | Shanta | Vollman | 3 | Renske | Ladwig | 3 | Stephen | Stiles | 3 | John | Seo | 3 | Joshua | Patel | 3 | Sarah | Bell | 3 | Britney | Everett | 3 | Samuel | McCain | 3 | Vance | Jones | 2 | Kevin | Mourgos | 3 | Trenna | Rajs | 3 | Curtis | Davies | 3 | Randall | Matos | 3 | Peter | Vargas | 3 | Alana | Walsh | 3 | Kevin | Feeney | 3 | Donald | OConnell | 3 | Douglas | Grant | 2 | John | Russell | 3 | Peter | Tucker | 3 | David | Bernstein | 3 | Peter | Hall | 3 | Christopher | Olsen | 3 | Nanette | Cambrault | 3 | Oliver | Tuvault | 2 | Karen | Partners | 3 | Janette | King | 3 | Patrick | Sully | 3 | Allan | McEwen | 3 | Lindsey | Smith | 3 | Louise | Doran | 3 | Sarath | Sewall | 2 | Alberto | Errazuriz | 3 | Clara | Vishney | 3 | Danielle | Greene | 3 | Mattea | Marvins | 3 | David | Lee | 3 | Sundar | Ande | 3 | Amit | Banda | 2 | Gerald | Cambrault | 3 | Lisa | Ozer | 3 | Harrison | Bloom | 3 | Tayler | Fox | 3 | William | Smith | 3 | Elizabeth | Bates | 3 | Sundita | Kumar | 2 | Eleni | Zlotkey | 3 | Ellen | Abel | 3 | Alyssa | Hutton | 3 | Jonathon | Taylor | 3 | Jack | Livingston | 3 | Kimberely | Grant | 3 | Charles | Johnson | 2 | Michael | Hartstein | 3 | Pat | Fay |
|---|
Create View emp_names As
Select employee_id, first_name, last_name From hr.employeesORA-00955: name is already used by an existing objectMore Details: https://docs.oracle.com/error-help/db/ora-00955
Select level, n.first_name, n.last_name
From emp_hierarchy h,
hierarchy_versions v,
emp_names n
Where h.version = v.version
And n.employee_id = h.employee_id
And v.primary_hier = 'Y'
Start With h.employee_id = 100
Connect By Prior h.employee_id = h.manager_id
And Prior h.version = h.version| LEVEL | FIRST_NAME | LAST_NAME | 1 | Steven | King | 2 | Neena | Kochhar | 3 | Nancy | Greenberg | 4 | Daniel | Faviet | 4 | Daniel | FavietO | 4 | John | Chen | 4 | John | ChenO | 4 | Ismael | Sciarra | 4 | Ismael | SciarraO | 4 | Jose Manuel | Urman | 4 | Jose Manuel | UrmanO | 4 | Luis | Popp | 4 | Luis | PoppO | 3 | Nancy | GreenbergO | 4 | Daniel | Faviet | 4 | Daniel | FavietO | 4 | John | Chen | 4 | John | ChenO | 4 | Ismael | Sciarra | 4 | Ismael | SciarraO | 4 | Jose Manuel | Urman | 4 | Jose Manuel | UrmanO | 4 | Luis | Popp | 4 | Luis | PoppO | 3 | Jennifer | Whalen | 3 | Jennifer | WhalenO | 3 | Susan | Mavris | 3 | Susan | MavrisO | 3 | Hermann | Baer | 3 | Hermann | BaerO | 3 | Shelley | Higgins | 4 | William | Gietz | 4 | William | GietzO | 3 | Shelley | HigginsO | 4 | William | Gietz | 4 | William | GietzO | 2 | Neena | KochharO | 3 | Nancy | Greenberg | 4 | Daniel | Faviet | 4 | Daniel | FavietO | 4 | John | Chen | 4 | John | ChenO | 4 | Ismael | Sciarra | 4 | Ismael | SciarraO | 4 | Jose Manuel | Urman | 4 | Jose Manuel | UrmanO | 4 | Luis | Popp | 4 | Luis | PoppO | 3 | Nancy | GreenbergO | 4 | Daniel | Faviet | 4 | Daniel | FavietO | 4 | John | Chen | 4 | John | ChenO | 4 | Ismael | Sciarra | 4 | Ismael | SciarraO | 4 | Jose Manuel | Urman | 4 | Jose Manuel | UrmanO | 4 | Luis | Popp | 4 | Luis | PoppO | 3 | Jennifer | Whalen | 3 | Jennifer | WhalenO | 3 | Susan | Mavris | 3 | Susan | MavrisO | 3 | Hermann | Baer | 3 | Hermann | BaerO | 3 | Shelley | Higgins | 4 | William | Gietz | 4 | William | GietzO | 3 | Shelley | HigginsO | 4 | William | Gietz | 4 | William | GietzO | 2 | Lex | De Haan | 3 | Alexander | Hunold | 4 | Bruce | Ernst | 4 | Bruce | ErnstO | 4 | David | Austin | 4 | David | AustinO | 4 | Valli | Pataballa | 4 | Valli | PataballaO | 4 | Diana | Lorentz | 4 | Diana | LorentzO | 3 | Alexander | HunoldO | 4 | Bruce | Ernst | 4 | Bruce | ErnstO | 4 | David | Austin | 4 | David | AustinO | 4 | Valli | Pataballa | 4 | Valli | PataballaO | 4 | Diana | Lorentz | 4 | Diana | LorentzO | 2 | Lex | De HaanO | 3 | Alexander | Hunold | 4 | Bruce | Ernst | 4 | Bruce | ErnstO | 4 | David | Austin | 4 | David | AustinO | 4 | Valli | Pataballa | 4 | Valli | PataballaO | 4 | Diana | Lorentz | 4 | Diana | LorentzO | 3 | Alexander | HunoldO | 4 | Bruce | Ernst | 4 | Bruce | ErnstO | 4 | David | Austin | 4 | David | AustinO | 4 | Valli | Pataballa | 4 | Valli | PataballaO | 4 | Diana | Lorentz | 4 | Diana | LorentzO | 2 | Den | Raphaely | 3 | Alexander | Khoo | 3 | Alexander | KhooO | 3 | Shelli | Baida | 3 | Shelli | BaidaO | 3 | Sigal | Tobias | 3 | Sigal | TobiasO | 3 | Guy | Himuro | 3 | Guy | HimuroO | 3 | Karen | Colmenares | 3 | Karen | ColmenaresO | 2 | Den | RaphaelyO | 3 | Alexander | Khoo | 3 | Alexander | KhooO | 3 | Shelli | Baida | 3 | Shelli | BaidaO | 3 | Sigal | Tobias | 3 | Sigal | TobiasO | 3 | Guy | Himuro | 3 | Guy | HimuroO | 3 | Karen | Colmenares | 3 | Karen | ColmenaresO | 2 | Matthew | Weiss | 3 | Julia | Nayer | 3 | Julia | NayerO | 3 | Irene | Mikkilineni | 3 | Irene | MikkilineniO | 3 | James | Landry | 3 | James | LandryO | 3 | Steven | Markle | 3 | Steven | MarkleO | 3 | Winston | Taylor | 3 | Winston | TaylorO | 3 | Jean | Fleaur | 3 | Jean | FleaurO | 3 | Martha | Sullivan | 3 | Martha | SullivanO | 3 | Girard | Geoni | 3 | Girard | GeoniO | 2 | Matthew | WeissO | 3 | Julia | Nayer | 3 | Julia | NayerO | 3 | Irene | Mikkilineni | 3 | Irene | MikkilineniO | 3 | James | Landry | 3 | James | LandryO | 3 | Steven | Markle | 3 | Steven | MarkleO | 3 | Winston | Taylor | 3 | Winston | TaylorO | 3 | Jean | Fleaur | 3 | Jean | FleaurO | 3 | Martha | Sullivan | 3 | Martha | SullivanO | 3 | Girard | Geoni | 3 | Girard | GeoniO | 2 | Adam | Fripp | 3 | Laura | Bissot | 3 | Laura | BissotO | 3 | Mozhe | Atkinson | 3 | Mozhe | AtkinsonO | 3 | James | Marlow | 3 | James | MarlowO | 3 | TJ | Olson | 3 | TJ | OlsonO | 3 | Nandita | Sarchand | 3 | Nandita | SarchandO | 3 | Alexis | Bull | 3 | Alexis | BullO | 3 | Julia | Dellinger | 3 | Julia | DellingerO | 3 | Anthony | Cabrio | 3 | Anthony | CabrioO | 2 | Adam | FrippO | 3 | Laura | Bissot | 3 | Laura | BissotO | 3 | Mozhe | Atkinson | 3 | Mozhe | AtkinsonO | 3 | James | Marlow | 3 | James | MarlowO | 3 | TJ | Olson | 3 | TJ | OlsonO | 3 | Nandita | Sarchand | 3 | Nandita | SarchandO | 3 | Alexis | Bull | 3 | Alexis | BullO | 3 | Julia | Dellinger | 3 | Julia | DellingerO | 3 | Anthony | Cabrio | 3 | Anthony | CabrioO | 2 | Payam | Kaufling | 3 | Jason | Mallin | 3 | Jason | MallinO | 3 | Michael | Rogers | 3 | Michael | RogersO | 3 | Ki | Gee | 3 | Ki | GeeO | 3 | Hazel | Philtanker | 3 | Hazel | PhiltankerO | 3 | Kelly | Chung | 3 | Kelly | ChungO | 3 | Jennifer | Dilly | 3 | Jennifer | DillyO | 3 | Timothy | Gates | 3 | Timothy | GatesO | 3 | Randall | Perkins | 3 | Randall | PerkinsO | 2 | Payam | KauflingO | 3 | Jason | Mallin | 3 | Jason | MallinO | 3 | Michael | Rogers | 3 | Michael | RogersO | 3 | Ki | Gee | 3 | Ki | GeeO | 3 | Hazel | Philtanker | 3 | Hazel | PhiltankerO | 3 | Kelly | Chung | 3 | Kelly | ChungO | 3 | Jennifer | Dilly | 3 | Jennifer | DillyO | 3 | Timothy | Gates | 3 | Timothy | GatesO | 3 | Randall | Perkins | 3 | Randall | PerkinsO | 2 | Shanta | Vollman | 3 | Renske | Ladwig | 3 | Renske | LadwigO | 3 | Stephen | Stiles | 3 | Stephen | StilesO | 3 | John | Seo | 3 | John | SeoO | 3 | Joshua | Patel | 3 | Joshua | PatelO | 3 | Sarah | Bell | 3 | Sarah | BellO | 3 | Britney | Everett | 3 | Britney | EverettO | 3 | Samuel | McCain | 3 | Samuel | McCainO | 3 | Vance | Jones | 3 | Vance | JonesO | 2 | Shanta | VollmanO | 3 | Renske | Ladwig | 3 | Renske | LadwigO | 3 | Stephen | Stiles | 3 | Stephen | StilesO | 3 | John | Seo | 3 | John | SeoO | 3 | Joshua | Patel | 3 | Joshua | PatelO | 3 | Sarah | Bell | 3 | Sarah | BellO | 3 | Britney | Everett | 3 | Britney | EverettO | 3 | Samuel | McCain | 3 | Samuel | McCainO | 3 | Vance | Jones | 3 | Vance | JonesO | 2 | Kevin | Mourgos | 3 | Trenna | Rajs | 3 | Trenna | RajsO | 3 | Curtis | Davies | 3 | Curtis | DaviesO | 3 | Randall | Matos | 3 | Randall | MatosO | 3 | Peter | Vargas | 3 | Peter | VargasO | 3 | Alana | Walsh | 3 | Alana | WalshO | 3 | Kevin | Feeney | 3 | Kevin | FeeneyO | 3 | Donald | OConnell | 3 | Donald | OConnellO | 3 | Douglas | Grant | 3 | Douglas | GrantO | 2 | Kevin | MourgosO | 3 | Trenna | Rajs | 3 | Trenna | RajsO | 3 | Curtis | Davies | 3 | Curtis | DaviesO | 3 | Randall | Matos | 3 | Randall | MatosO | 3 | Peter | Vargas | 3 | Peter | VargasO | 3 | Alana | Walsh | 3 | Alana | WalshO | 3 | Kevin | Feeney | 3 | Kevin | FeeneyO | 3 | Donald | OConnell | 3 | Donald | OConnellO | 3 | Douglas | Grant | 3 | Douglas | GrantO | 2 | John | Russell | 3 | Peter | Tucker | 3 | Peter | TuckerO | 3 | David | Bernstein | 3 | David | BernsteinO | 3 | Peter | Hall | 3 | Peter | HallO | 3 | Christopher | Olsen | 3 | Christopher | OlsenO | 3 | Nanette | Cambrault | 3 | Nanette | CambraultO | 3 | Oliver | Tuvault | 3 | Oliver | TuvaultO | 2 | John | RussellO | 3 | Peter | Tucker | 3 | Peter | TuckerO | 3 | David | Bernstein | 3 | David | BernsteinO | 3 | Peter | Hall | 3 | Peter | HallO | 3 | Christopher | Olsen | 3 | Christopher | OlsenO | 3 | Nanette | Cambrault | 3 | Nanette | CambraultO | 3 | Oliver | Tuvault | 3 | Oliver | TuvaultO | 2 | Karen | Partners | 3 | Janette | King | 3 | Janette | KingO | 3 | Patrick | Sully | 3 | Patrick | SullyO | 3 | Allan | McEwen | 3 | Allan | McEwenO | 3 | Lindsey | Smith | 3 | Lindsey | SmithO | 3 | Louise | Doran | 3 | Louise | DoranO | 3 | Sarath | Sewall | 3 | Sarath | SewallO | 2 | Karen | PartnersO | 3 | Janette | King | 3 | Janette | KingO | 3 | Patrick | Sully | 3 | Patrick | SullyO | 3 | Allan | McEwen | 3 | Allan | McEwenO | 3 | Lindsey | Smith | 3 | Lindsey | SmithO | 3 | Louise | Doran | 3 | Louise | DoranO | 3 | Sarath | Sewall | 3 | Sarath | SewallO | 2 | Alberto | Errazuriz | 3 | Clara | Vishney | 3 | Clara | VishneyO | 3 | Danielle | Greene | 3 | Danielle | GreeneO | 3 | Mattea | Marvins | 3 | Mattea | MarvinsO | 3 | David | Lee | 3 | David | LeeO | 3 | Sundar | Ande | 3 | Sundar | AndeO | 3 | Amit | Banda | 3 | Amit | BandaO | 2 | Alberto | ErrazurizO | 3 | Clara | Vishney | 3 | Clara | VishneyO | 3 | Danielle | Greene | 3 | Danielle | GreeneO | 3 | Mattea | Marvins | 3 | Mattea | MarvinsO | 3 | David | Lee | 3 | David | LeeO | 3 | Sundar | Ande | 3 | Sundar | AndeO | 3 | Amit | Banda | 3 | Amit | BandaO | 2 | Gerald | Cambrault | 3 | Lisa | Ozer | 3 | Lisa | OzerO | 3 | Harrison | Bloom | 3 | Harrison | BloomO | 3 | Tayler | Fox | 3 | Tayler | FoxO | 3 | William | Smith | 3 | William | SmithO | 3 | Elizabeth | Bates | 3 | Elizabeth | BatesO | 3 | Sundita | Kumar | 3 | Sundita | KumarO | 2 | Gerald | CambraultO | 3 | Lisa | Ozer | 3 | Lisa | OzerO | 3 | Harrison | Bloom | 3 | Harrison | BloomO | 3 | Tayler | Fox | 3 | Tayler | FoxO | 3 | William | Smith | 3 | William | SmithO | 3 | Elizabeth | Bates | 3 | Elizabeth | BatesO | 3 | Sundita | Kumar | 3 | Sundita | KumarO | 2 | Eleni | Zlotkey | 3 | Ellen | Abel | 3 | Ellen | AbelO | 3 | Alyssa | Hutton | 3 | Alyssa | HuttonO | 3 | Jonathon | Taylor | 3 | Jonathon | TaylorO | 3 | Jack | Livingston | 3 | Jack | LivingstonO | 3 | Kimberely | Grant | 3 | Kimberely | GrantO | 3 | Charles | Johnson | 3 | Charles | JohnsonO | 2 | Eleni | ZlotkeyO | 3 | Ellen | Abel | 3 | Ellen | AbelO | 3 | Alyssa | Hutton | 3 | Alyssa | HuttonO | 3 | Jonathon | Taylor | 3 | Jonathon | TaylorO | 3 | Jack | Livingston | 3 | Jack | LivingstonO | 3 | Kimberely | Grant | 3 | Kimberely | GrantO | 3 | Charles | Johnson | 3 | Charles | JohnsonO | 2 | Michael | Hartstein | 3 | Pat | Fay | 3 | Pat | FayO | 2 | Michael | HartsteinO | 3 | Pat | Fay | 3 | Pat | FayO | 1 | Steven | KingO | 2 | Neena | Kochhar | 3 | Nancy | Greenberg | 4 | Daniel | Faviet | 4 | Daniel | FavietO | 4 | John | Chen | 4 | John | ChenO | 4 | Ismael | Sciarra | 4 | Ismael | SciarraO | 4 | Jose Manuel | Urman | 4 | Jose Manuel | UrmanO | 4 | Luis | Popp | 4 | Luis | PoppO | 3 | Nancy | GreenbergO | 4 | Daniel | Faviet | 4 | Daniel | FavietO | 4 | John | Chen | 4 | John | ChenO | 4 | Ismael | Sciarra | 4 | Ismael | SciarraO | 4 | Jose Manuel | Urman | 4 | Jose Manuel | UrmanO | 4 | Luis | Popp | 4 | Luis | PoppO | 3 | Jennifer | Whalen | 3 | Jennifer | WhalenO | 3 | Susan | Mavris | 3 | Susan | MavrisO | 3 | Hermann | Baer | 3 | Hermann | BaerO | 3 | Shelley | Higgins | 4 | William | Gietz | 4 | William | GietzO | 3 | Shelley | HigginsO | 4 | William | Gietz | 4 | William | GietzO | 2 | Neena | KochharO | 3 | Nancy | Greenberg | 4 | Daniel | Faviet | 4 | Daniel | FavietO | 4 | John | Chen | 4 | John | ChenO | 4 | Ismael | Sciarra | 4 | Ismael | SciarraO | 4 | Jose Manuel | Urman | 4 | Jose Manuel | UrmanO | 4 | Luis | Popp | 4 | Luis | PoppO | 3 | Nancy | GreenbergO | 4 | Daniel | Faviet | 4 | Daniel | FavietO | 4 | John | Chen | 4 | John | ChenO | 4 | Ismael | Sciarra | 4 | Ismael | SciarraO | 4 | Jose Manuel | Urman | 4 | Jose Manuel | UrmanO | 4 | Luis | Popp | 4 | Luis | PoppO | 3 | Jennifer | Whalen | 3 | Jennifer | WhalenO | 3 | Susan | Mavris | 3 | Susan | MavrisO | 3 | Hermann | Baer | 3 | Hermann | BaerO | 3 | Shelley | Higgins | 4 | William | Gietz | 4 | William | GietzO | 3 | Shelley | HigginsO | 4 | William | Gietz | 4 | William | GietzO | 2 | Lex | De Haan | 3 | Alexander | Hunold | 4 | Bruce | Ernst | 4 | Bruce | ErnstO | 4 | David | Austin | 4 | David | AustinO | 4 | Valli | Pataballa | 4 | Valli | PataballaO | 4 | Diana | Lorentz | 4 | Diana | LorentzO | 3 | Alexander | HunoldO | 4 | Bruce | Ernst | 4 | Bruce | ErnstO | 4 | David | Austin | 4 | David | AustinO | 4 | Valli | Pataballa | 4 | Valli | PataballaO | 4 | Diana | Lorentz | 4 | Diana | LorentzO | 2 | Lex | De HaanO | 3 | Alexander | Hunold | 4 | Bruce | Ernst | 4 | Bruce | ErnstO | 4 | David | Austin | 4 | David | AustinO | 4 | Valli | Pataballa | 4 | Valli | PataballaO | 4 | Diana | Lorentz | 4 | Diana | LorentzO | 3 | Alexander | HunoldO | 4 | Bruce | Ernst | 4 | Bruce | ErnstO | 4 | David | Austin | 4 | David | AustinO | 4 | Valli | Pataballa | 4 | Valli | PataballaO | 4 | Diana | Lorentz | 4 | Diana | LorentzO | 2 | Den | Raphaely | 3 | Alexander | Khoo | 3 | Alexander | KhooO | 3 | Shelli | Baida | 3 | Shelli | BaidaO | 3 | Sigal | Tobias | 3 | Sigal | TobiasO | 3 | Guy | Himuro | 3 | Guy | HimuroO | 3 | Karen | Colmenares | 3 | Karen | ColmenaresO | 2 | Den | RaphaelyO | 3 | Alexander | Khoo | 3 | Alexander | KhooO | 3 | Shelli | Baida | 3 | Shelli | BaidaO | 3 | Sigal | Tobias | 3 | Sigal | TobiasO | 3 | Guy | Himuro | 3 | Guy | HimuroO | 3 | Karen | Colmenares | 3 | Karen | ColmenaresO | 2 | Matthew | Weiss | 3 | Julia | Nayer | 3 | Julia | NayerO | 3 | Irene | Mikkilineni | 3 | Irene | MikkilineniO | 3 | James | Landry | 3 | James | LandryO | 3 | Steven | Markle | 3 | Steven | MarkleO | 3 | Winston | Taylor | 3 | Winston | TaylorO | 3 | Jean | Fleaur | 3 | Jean | FleaurO | 3 | Martha | Sullivan | 3 | Martha | SullivanO | 3 | Girard | Geoni | 3 | Girard | GeoniO | 2 | Matthew | WeissO | 3 | Julia | Nayer | 3 | Julia | NayerO | 3 | Irene | Mikkilineni | 3 | Irene | MikkilineniO | 3 | James | Landry | 3 | James | LandryO | 3 | Steven | Markle | 3 | Steven | MarkleO | 3 | Winston | Taylor | 3 | Winston | TaylorO | 3 | Jean | Fleaur | 3 | Jean | FleaurO | 3 | Martha | Sullivan | 3 | Martha | SullivanO | 3 | Girard | Geoni | 3 | Girard | GeoniO | 2 | Adam | Fripp | 3 | Laura | Bissot | 3 | Laura | BissotO | 3 | Mozhe | Atkinson | 3 | Mozhe | AtkinsonO | 3 | James | Marlow | 3 | James | MarlowO | 3 | TJ | Olson | 3 | TJ | OlsonO | 3 | Nandita | Sarchand | 3 | Nandita | SarchandO | 3 | Alexis | Bull | 3 | Alexis | BullO | 3 | Julia | Dellinger | 3 | Julia | DellingerO | 3 | Anthony | Cabrio | 3 | Anthony | CabrioO | 2 | Adam | FrippO | 3 | Laura | Bissot | 3 | Laura | BissotO | 3 | Mozhe | Atkinson | 3 | Mozhe | AtkinsonO | 3 | James | Marlow | 3 | James | MarlowO | 3 | TJ | Olson | 3 | TJ | OlsonO | 3 | Nandita | Sarchand | 3 | Nandita | SarchandO | 3 | Alexis | Bull | 3 | Alexis | BullO | 3 | Julia | Dellinger | 3 | Julia | DellingerO | 3 | Anthony | Cabrio | 3 | Anthony | CabrioO | 2 | Payam | Kaufling | 3 | Jason | Mallin | 3 | Jason | MallinO | 3 | Michael | Rogers | 3 | Michael | RogersO | 3 | Ki | Gee | 3 | Ki | GeeO | 3 | Hazel | Philtanker | 3 | Hazel | PhiltankerO | 3 | Kelly | Chung | 3 | Kelly | ChungO | 3 | Jennifer | Dilly | 3 | Jennifer | DillyO | 3 | Timothy | Gates | 3 | Timothy | GatesO | 3 | Randall | Perkins | 3 | Randall | PerkinsO | 2 | Payam | KauflingO | 3 | Jason | Mallin | 3 | Jason | MallinO | 3 | Michael | Rogers | 3 | Michael | RogersO | 3 | Ki | Gee | 3 | Ki | GeeO | 3 | Hazel | Philtanker | 3 | Hazel | PhiltankerO | 3 | Kelly | Chung | 3 | Kelly | ChungO | 3 | Jennifer | Dilly | 3 | Jennifer | DillyO | 3 | Timothy | Gates | 3 | Timothy | GatesO | 3 | Randall | Perkins | 3 | Randall | PerkinsO | 2 | Shanta | Vollman | 3 | Renske | Ladwig | 3 | Renske | LadwigO | 3 | Stephen | Stiles | 3 | Stephen | StilesO | 3 | John | Seo | 3 | John | SeoO | 3 | Joshua | Patel | 3 | Joshua | PatelO | 3 | Sarah | Bell | 3 | Sarah | BellO | 3 | Britney | Everett | 3 | Britney | EverettO | 3 | Samuel | McCain | 3 | Samuel | McCainO | 3 | Vance | Jones | 3 | Vance | JonesO | 2 | Shanta | VollmanO | 3 | Renske | Ladwig | 3 | Renske | LadwigO | 3 | Stephen | Stiles | 3 | Stephen | StilesO | 3 | John | Seo | 3 | John | SeoO | 3 | Joshua | Patel | 3 | Joshua | PatelO | 3 | Sarah | Bell | 3 | Sarah | BellO | 3 | Britney | Everett | 3 | Britney | EverettO | 3 | Samuel | McCain | 3 | Samuel | McCainO | 3 | Vance | Jones | 3 | Vance | JonesO | 2 | Kevin | Mourgos | 3 | Trenna | Rajs | 3 | Trenna | RajsO | 3 | Curtis | Davies | 3 | Curtis | DaviesO | 3 | Randall | Matos | 3 | Randall | MatosO | 3 | Peter | Vargas | 3 | Peter | VargasO | 3 | Alana | Walsh | 3 | Alana | WalshO | 3 | Kevin | Feeney | 3 | Kevin | FeeneyO | 3 | Donald | OConnell | 3 | Donald | OConnellO | 3 | Douglas | Grant | 3 | Douglas | GrantO | 2 | Kevin | MourgosO | 3 | Trenna | Rajs | 3 | Trenna | RajsO | 3 | Curtis | Davies | 3 | Curtis | DaviesO | 3 | Randall | Matos | 3 | Randall | MatosO | 3 | Peter | Vargas | 3 | Peter | VargasO | 3 | Alana | Walsh | 3 | Alana | WalshO | 3 | Kevin | Feeney | 3 | Kevin | FeeneyO | 3 | Donald | OConnell | 3 | Donald | OConnellO | 3 | Douglas | Grant | 3 | Douglas | GrantO | 2 | John | Russell | 3 | Peter | Tucker | 3 | Peter | TuckerO | 3 | David | Bernstein | 3 | David | BernsteinO | 3 | Peter | Hall | 3 | Peter | HallO | 3 | Christopher | Olsen | 3 | Christopher | OlsenO | 3 | Nanette | Cambrault | 3 | Nanette | CambraultO | 3 | Oliver | Tuvault | 3 | Oliver | TuvaultO | 2 | John | RussellO | 3 | Peter | Tucker | 3 | Peter | TuckerO | 3 | David | Bernstein | 3 | David | BernsteinO | 3 | Peter | Hall | 3 | Peter | HallO | 3 | Christopher | Olsen | 3 | Christopher | OlsenO | 3 | Nanette | Cambrault | 3 | Nanette | CambraultO | 3 | Oliver | Tuvault | 3 | Oliver | TuvaultO | 2 | Karen | Partners | 3 | Janette | King | 3 | Janette | KingO | 3 | Patrick | Sully | 3 | Patrick | SullyO | 3 | Allan | McEwen | 3 | Allan | McEwenO | 3 | Lindsey | Smith | 3 | Lindsey | SmithO | 3 | Louise | Doran | 3 | Louise | DoranO | 3 | Sarath | Sewall | 3 | Sarath | SewallO | 2 | Karen | PartnersO | 3 | Janette | King | 3 | Janette | KingO | 3 | Patrick | Sully | 3 | Patrick | SullyO | 3 | Allan | McEwen | 3 | Allan | McEwenO | 3 | Lindsey | Smith | 3 | Lindsey | SmithO | 3 | Louise | Doran | 3 | Louise | DoranO | 3 | Sarath | Sewall | 3 | Sarath | SewallO | 2 | Alberto | Errazuriz | 3 | Clara | Vishney | 3 | Clara | VishneyO | 3 | Danielle | Greene | 3 | Danielle | GreeneO | 3 | Mattea | Marvins | 3 | Mattea | MarvinsO | 3 | David | Lee | 3 | David | LeeO | 3 | Sundar | Ande | 3 | Sundar | AndeO | 3 | Amit | Banda | 3 | Amit | BandaO | 2 | Alberto | ErrazurizO | 3 | Clara | Vishney | 3 | Clara | VishneyO | 3 | Danielle | Greene | 3 | Danielle | GreeneO | 3 | Mattea | Marvins | 3 | Mattea | MarvinsO | 3 | David | Lee | 3 | David | LeeO | 3 | Sundar | Ande | 3 | Sundar | AndeO | 3 | Amit | Banda | 3 | Amit | BandaO | 2 | Gerald | Cambrault | 3 | Lisa | Ozer | 3 | Lisa | OzerO | 3 | Harrison | Bloom | 3 | Harrison | BloomO | 3 | Tayler | Fox | 3 | Tayler | FoxO | 3 | William | Smith | 3 | William | SmithO | 3 | Elizabeth | Bates | 3 | Elizabeth | BatesO | 3 | Sundita | Kumar | 3 | Sundita | KumarO | 2 | Gerald | CambraultO | 3 | Lisa | Ozer | 3 | Lisa | OzerO | 3 | Harrison | Bloom | 3 | Harrison | BloomO | 3 | Tayler | Fox | 3 | Tayler | FoxO | 3 | William | Smith | 3 | William | SmithO | 3 | Elizabeth | Bates | 3 | Elizabeth | BatesO | 3 | Sundita | Kumar | 3 | Sundita | KumarO | 2 | Eleni | Zlotkey | 3 | Ellen | Abel | 3 | Ellen | AbelO | 3 | Alyssa | Hutton | 3 | Alyssa | HuttonO | 3 | Jonathon | Taylor | 3 | Jonathon | TaylorO | 3 | Jack | Livingston | 3 | Jack | LivingstonO | 3 | Kimberely | Grant | 3 | Kimberely | GrantO | 3 | Charles | Johnson | 3 | Charles | JohnsonO | 2 | Eleni | ZlotkeyO | 3 | Ellen | Abel | 3 | Ellen | AbelO | 3 | Alyssa | Hutton | 3 | Alyssa | HuttonO | 3 | Jonathon | Taylor | 3 | Jonathon | TaylorO | 3 | Jack | Livingston | 3 | Jack | LivingstonO | 3 | Kimberely | Grant | 3 | Kimberely | GrantO | 3 | Charles | Johnson | 3 | Charles | JohnsonO | 2 | Michael | Hartstein | 3 | Pat | Fay | 3 | Pat | FayO | 2 | Michael | HartsteinO | 3 | Pat | Fay | 3 | Pat | FayO |
|---|
Create or Replace View emp_names As
Select employee_id, first_name, last_name, 'UK' lang From hr.employees Union All
Select employee_id, first_name, last_name || 'o', 'SPANISH' lang From hr.employeesView created.
Select level, n.first_name, n.last_name
From emp_hierarchy h,
hierarchy_versions v,
emp_names n
Where h.version = v.version
And n.employee_id = h.employee_id
And v.primary_hier = 'Y'
And n.lang='SPANISH'
Start With h.employee_id = 100
Connect By Prior h.employee_id = h.manager_id
And Prior h.version = h.version| LEVEL | FIRST_NAME | LAST_NAME | 4 | Daniel | Favieto | 4 | John | Cheno | 4 | Ismael | Sciarrao | 4 | Jose Manuel | Urmano | 4 | Luis | Poppo | 3 | Nancy | Greenbergo | 4 | Daniel | Favieto | 4 | John | Cheno | 4 | Ismael | Sciarrao | 4 | Jose Manuel | Urmano | 4 | Luis | Poppo | 3 | Jennifer | Whaleno | 3 | Susan | Mavriso | 3 | Hermann | Baero | 4 | William | Gietzo | 3 | Shelley | Higginso | 4 | William | Gietzo | 2 | Neena | Kochharo | 4 | Daniel | Favieto | 4 | John | Cheno | 4 | Ismael | Sciarrao | 4 | Jose Manuel | Urmano | 4 | Luis | Poppo | 3 | Nancy | Greenbergo | 4 | Daniel | Favieto | 4 | John | Cheno | 4 | Ismael | Sciarrao | 4 | Jose Manuel | Urmano | 4 | Luis | Poppo | 3 | Jennifer | Whaleno | 3 | Susan | Mavriso | 3 | Hermann | Baero | 4 | William | Gietzo | 3 | Shelley | Higginso | 4 | William | Gietzo | 4 | Bruce | Ernsto | 4 | David | Austino | 4 | Valli | Pataballao | 4 | Diana | Lorentzo | 3 | Alexander | Hunoldo | 4 | Bruce | Ernsto | 4 | David | Austino | 4 | Valli | Pataballao | 4 | Diana | Lorentzo | 2 | Lex | De Haano | 4 | Bruce | Ernsto | 4 | David | Austino | 4 | Valli | Pataballao | 4 | Diana | Lorentzo | 3 | Alexander | Hunoldo | 4 | Bruce | Ernsto | 4 | David | Austino | 4 | Valli | Pataballao | 4 | Diana | Lorentzo | 3 | Alexander | Khooo | 3 | Shelli | Baidao | 3 | Sigal | Tobiaso | 3 | Guy | Himuroo | 3 | Karen | Colmenareso | 2 | Den | Raphaelyo | 3 | Alexander | Khooo | 3 | Shelli | Baidao | 3 | Sigal | Tobiaso | 3 | Guy | Himuroo | 3 | Karen | Colmenareso | 3 | Julia | Nayero | 3 | Irene | Mikkilinenio | 3 | James | Landryo | 3 | Steven | Markleo | 3 | Winston | Tayloro | 3 | Jean | Fleauro | 3 | Martha | Sullivano | 3 | Girard | Geonio | 2 | Matthew | Weisso | 3 | Julia | Nayero | 3 | Irene | Mikkilinenio | 3 | James | Landryo | 3 | Steven | Markleo | 3 | Winston | Tayloro | 3 | Jean | Fleauro | 3 | Martha | Sullivano | 3 | Girard | Geonio | 3 | Laura | Bissoto | 3 | Mozhe | Atkinsono | 3 | James | Marlowo | 3 | TJ | Olsono | 3 | Nandita | Sarchando | 3 | Alexis | Bullo | 3 | Julia | Dellingero | 3 | Anthony | Cabrioo | 2 | Adam | Frippo | 3 | Laura | Bissoto | 3 | Mozhe | Atkinsono | 3 | James | Marlowo | 3 | TJ | Olsono | 3 | Nandita | Sarchando | 3 | Alexis | Bullo | 3 | Julia | Dellingero | 3 | Anthony | Cabrioo | 3 | Jason | Mallino | 3 | Michael | Rogerso | 3 | Ki | Geeo | 3 | Hazel | Philtankero | 3 | Kelly | Chungo | 3 | Jennifer | Dillyo | 3 | Timothy | Gateso | 3 | Randall | Perkinso | 2 | Payam | Kauflingo | 3 | Jason | Mallino | 3 | Michael | Rogerso | 3 | Ki | Geeo | 3 | Hazel | Philtankero | 3 | Kelly | Chungo | 3 | Jennifer | Dillyo | 3 | Timothy | Gateso | 3 | Randall | Perkinso | 3 | Renske | Ladwigo | 3 | Stephen | Stileso | 3 | John | Seoo | 3 | Joshua | Patelo | 3 | Sarah | Bello | 3 | Britney | Everetto | 3 | Samuel | McCaino | 3 | Vance | Joneso | 2 | Shanta | Vollmano | 3 | Renske | Ladwigo | 3 | Stephen | Stileso | 3 | John | Seoo | 3 | Joshua | Patelo | 3 | Sarah | Bello | 3 | Britney | Everetto | 3 | Samuel | McCaino | 3 | Vance | Joneso | 3 | Trenna | Rajso | 3 | Curtis | Davieso | 3 | Randall | Matoso | 3 | Peter | Vargaso | 3 | Alana | Walsho | 3 | Kevin | Feeneyo | 3 | Donald | OConnello | 3 | Douglas | Granto | 2 | Kevin | Mourgoso | 3 | Trenna | Rajso | 3 | Curtis | Davieso | 3 | Randall | Matoso | 3 | Peter | Vargaso | 3 | Alana | Walsho | 3 | Kevin | Feeneyo | 3 | Donald | OConnello | 3 | Douglas | Granto | 3 | Peter | Tuckero | 3 | David | Bernsteino | 3 | Peter | Hallo | 3 | Christopher | Olseno | 3 | Nanette | Cambraulto | 3 | Oliver | Tuvaulto | 2 | John | Russello | 3 | Peter | Tuckero | 3 | David | Bernsteino | 3 | Peter | Hallo | 3 | Christopher | Olseno | 3 | Nanette | Cambraulto | 3 | Oliver | Tuvaulto | 3 | Janette | Kingo | 3 | Patrick | Sullyo | 3 | Allan | McEweno | 3 | Lindsey | Smitho | 3 | Louise | Dorano | 3 | Sarath | Sewallo | 2 | Karen | Partnerso | 3 | Janette | Kingo | 3 | Patrick | Sullyo | 3 | Allan | McEweno | 3 | Lindsey | Smitho | 3 | Louise | Dorano | 3 | Sarath | Sewallo | 3 | Clara | Vishneyo | 3 | Danielle | Greeneo | 3 | Mattea | Marvinso | 3 | David | Leeo | 3 | Sundar | Andeo | 3 | Amit | Bandao | 2 | Alberto | Errazurizo | 3 | Clara | Vishneyo | 3 | Danielle | Greeneo | 3 | Mattea | Marvinso | 3 | David | Leeo | 3 | Sundar | Andeo | 3 | Amit | Bandao | 3 | Lisa | Ozero | 3 | Harrison | Bloomo | 3 | Tayler | Foxo | 3 | William | Smitho | 3 | Elizabeth | Bateso | 3 | Sundita | Kumaro | 2 | Gerald | Cambraulto | 3 | Lisa | Ozero | 3 | Harrison | Bloomo | 3 | Tayler | Foxo | 3 | William | Smitho | 3 | Elizabeth | Bateso | 3 | Sundita | Kumaro | 3 | Ellen | Abelo | 3 | Alyssa | Huttono | 3 | Jonathon | Tayloro | 3 | Jack | Livingstono | 3 | Kimberely | Granto | 3 | Charles | Johnsono | 2 | Eleni | Zlotkeyo | 3 | Ellen | Abelo | 3 | Alyssa | Huttono | 3 | Jonathon | Tayloro | 3 | Jack | Livingstono | 3 | Kimberely | Granto | 3 | Charles | Johnsono | 3 | Pat | Fayo | 2 | Michael | Hartsteino | 3 | Pat | Fayo | 1 | Steven | Kingo | 4 | Daniel | Favieto | 4 | John | Cheno | 4 | Ismael | Sciarrao | 4 | Jose Manuel | Urmano | 4 | Luis | Poppo | 3 | Nancy | Greenbergo | 4 | Daniel | Favieto | 4 | John | Cheno | 4 | Ismael | Sciarrao | 4 | Jose Manuel | Urmano | 4 | Luis | Poppo | 3 | Jennifer | Whaleno | 3 | Susan | Mavriso | 3 | Hermann | Baero | 4 | William | Gietzo | 3 | Shelley | Higginso | 4 | William | Gietzo | 2 | Neena | Kochharo | 4 | Daniel | Favieto | 4 | John | Cheno | 4 | Ismael | Sciarrao | 4 | Jose Manuel | Urmano | 4 | Luis | Poppo | 3 | Nancy | Greenbergo | 4 | Daniel | Favieto | 4 | John | Cheno | 4 | Ismael | Sciarrao | 4 | Jose Manuel | Urmano | 4 | Luis | Poppo | 3 | Jennifer | Whaleno | 3 | Susan | Mavriso | 3 | Hermann | Baero | 4 | William | Gietzo | 3 | Shelley | Higginso | 4 | William | Gietzo | 4 | Bruce | Ernsto | 4 | David | Austino | 4 | Valli | Pataballao | 4 | Diana | Lorentzo | 3 | Alexander | Hunoldo | 4 | Bruce | Ernsto | 4 | David | Austino | 4 | Valli | Pataballao | 4 | Diana | Lorentzo | 2 | Lex | De Haano | 4 | Bruce | Ernsto | 4 | David | Austino | 4 | Valli | Pataballao | 4 | Diana | Lorentzo | 3 | Alexander | Hunoldo | 4 | Bruce | Ernsto | 4 | David | Austino | 4 | Valli | Pataballao | 4 | Diana | Lorentzo | 3 | Alexander | Khooo | 3 | Shelli | Baidao | 3 | Sigal | Tobiaso | 3 | Guy | Himuroo | 3 | Karen | Colmenareso | 2 | Den | Raphaelyo | 3 | Alexander | Khooo | 3 | Shelli | Baidao | 3 | Sigal | Tobiaso | 3 | Guy | Himuroo | 3 | Karen | Colmenareso | 3 | Julia | Nayero | 3 | Irene | Mikkilinenio | 3 | James | Landryo | 3 | Steven | Markleo | 3 | Winston | Tayloro | 3 | Jean | Fleauro | 3 | Martha | Sullivano | 3 | Girard | Geonio | 2 | Matthew | Weisso | 3 | Julia | Nayero | 3 | Irene | Mikkilinenio | 3 | James | Landryo | 3 | Steven | Markleo | 3 | Winston | Tayloro | 3 | Jean | Fleauro | 3 | Martha | Sullivano | 3 | Girard | Geonio | 3 | Laura | Bissoto | 3 | Mozhe | Atkinsono | 3 | James | Marlowo | 3 | TJ | Olsono | 3 | Nandita | Sarchando | 3 | Alexis | Bullo | 3 | Julia | Dellingero | 3 | Anthony | Cabrioo | 2 | Adam | Frippo | 3 | Laura | Bissoto | 3 | Mozhe | Atkinsono | 3 | James | Marlowo | 3 | TJ | Olsono | 3 | Nandita | Sarchando | 3 | Alexis | Bullo | 3 | Julia | Dellingero | 3 | Anthony | Cabrioo | 3 | Jason | Mallino | 3 | Michael | Rogerso | 3 | Ki | Geeo | 3 | Hazel | Philtankero | 3 | Kelly | Chungo | 3 | Jennifer | Dillyo | 3 | Timothy | Gateso | 3 | Randall | Perkinso | 2 | Payam | Kauflingo | 3 | Jason | Mallino | 3 | Michael | Rogerso | 3 | Ki | Geeo | 3 | Hazel | Philtankero | 3 | Kelly | Chungo | 3 | Jennifer | Dillyo | 3 | Timothy | Gateso | 3 | Randall | Perkinso | 3 | Renske | Ladwigo | 3 | Stephen | Stileso | 3 | John | Seoo | 3 | Joshua | Patelo | 3 | Sarah | Bello | 3 | Britney | Everetto | 3 | Samuel | McCaino | 3 | Vance | Joneso | 2 | Shanta | Vollmano | 3 | Renske | Ladwigo | 3 | Stephen | Stileso | 3 | John | Seoo | 3 | Joshua | Patelo | 3 | Sarah | Bello | 3 | Britney | Everetto | 3 | Samuel | McCaino | 3 | Vance | Joneso | 3 | Trenna | Rajso | 3 | Curtis | Davieso | 3 | Randall | Matoso | 3 | Peter | Vargaso | 3 | Alana | Walsho | 3 | Kevin | Feeneyo | 3 | Donald | OConnello | 3 | Douglas | Granto | 2 | Kevin | Mourgoso | 3 | Trenna | Rajso | 3 | Curtis | Davieso | 3 | Randall | Matoso | 3 | Peter | Vargaso | 3 | Alana | Walsho | 3 | Kevin | Feeneyo | 3 | Donald | OConnello | 3 | Douglas | Granto | 3 | Peter | Tuckero | 3 | David | Bernsteino | 3 | Peter | Hallo | 3 | Christopher | Olseno | 3 | Nanette | Cambraulto | 3 | Oliver | Tuvaulto | 2 | John | Russello | 3 | Peter | Tuckero | 3 | David | Bernsteino | 3 | Peter | Hallo | 3 | Christopher | Olseno | 3 | Nanette | Cambraulto | 3 | Oliver | Tuvaulto | 3 | Janette | Kingo | 3 | Patrick | Sullyo | 3 | Allan | McEweno | 3 | Lindsey | Smitho | 3 | Louise | Dorano | 3 | Sarath | Sewallo | 2 | Karen | Partnerso | 3 | Janette | Kingo | 3 | Patrick | Sullyo | 3 | Allan | McEweno | 3 | Lindsey | Smitho | 3 | Louise | Dorano | 3 | Sarath | Sewallo | 3 | Clara | Vishneyo | 3 | Danielle | Greeneo | 3 | Mattea | Marvinso | 3 | David | Leeo | 3 | Sundar | Andeo | 3 | Amit | Bandao | 2 | Alberto | Errazurizo | 3 | Clara | Vishneyo | 3 | Danielle | Greeneo | 3 | Mattea | Marvinso | 3 | David | Leeo | 3 | Sundar | Andeo | 3 | Amit | Bandao | 3 | Lisa | Ozero | 3 | Harrison | Bloomo | 3 | Tayler | Foxo | 3 | William | Smitho | 3 | Elizabeth | Bateso | 3 | Sundita | Kumaro | 2 | Gerald | Cambraulto | 3 | Lisa | Ozero | 3 | Harrison | Bloomo | 3 | Tayler | Foxo | 3 | William | Smitho | 3 | Elizabeth | Bateso | 3 | Sundita | Kumaro | 3 | Ellen | Abelo | 3 | Alyssa | Huttono | 3 | Jonathon | Tayloro | 3 | Jack | Livingstono | 3 | Kimberely | Granto | 3 | Charles | Johnsono | 2 | Eleni | Zlotkeyo | 3 | Ellen | Abelo | 3 | Alyssa | Huttono | 3 | Jonathon | Tayloro | 3 | Jack | Livingstono | 3 | Kimberely | Granto | 3 | Charles | Johnsono | 3 | Pat | Fayo | 2 | Michael | Hartsteino | 3 | Pat | Fayo |
|---|