Re: Help using hierarchical query CONNECT BY clause

Hexathioorthooxalate wrote:
> What I want is SQL to retrieve the names of the people in the
organisation
> hierarchy that have as a job title "Sales Director" however their
boss must
> have a job title of "Vice President" and their boss must have the job
title
> of "President".

This is not hierarchical query. What you've said is

select ...
from employees grandchildren,
employees children,
employees parents
where grandchildren.foo = children.bar
and blah-blah-blah

> And I want these job titles to be configurable too, so that
> I can change them on-the-fly and perform different queries.
Bind variables? Received on Tue Feb 01 2005 - 18:35:43 CST