Link to home
Start Free TrialLog in
Avatar of finance_teacher
finance_teacher

asked on

Oracle -- Multiple SELECT statement (Part #2) ?

Below get ALL records, which is OK,
but I only want to get managers
tied to one employee.

Adding the below "WHERE" clause fails.

SELECT     LPAD(' ', (LEVEL - 1) * 3) || pos_code
      FROM COMPANY_POSITION_STRUCTURE_TAB T
      --where pos_code = '101/3802'
CONNECT BY PRIOR POS_CODE = SUP_POS_CODE
START WITH SUP_POS_CODE = '*'
----------------------------------------------------
What SELECT or PL/SQL will allow me to
enter '133/1115' and get the below, indented ?

100/1000 OWNER
  101/3005 PRESIDENT
    101/1111 VICE PRESIDENT
      211/1115 MANAGER
       133/1115 EMPLOYEE
----------------------------------------------------
What SELECT or PL/SQL will allow me to
enter '101/1111' and get the below, indented ?

100/1000 OWNER
  101/3005 PRESIDENT
    101/1111 VICE PRESIDENT

s001.jpg
ASKER CERTIFIED SOLUTION
Avatar of cklautau
cklautau
Flag of Brazil image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I forgot to comment what has changed: I just changed the side where the PRIOR was used.