I'm very rusty on my SQL, and I have to work on a query that looks something like the following:
select * from (
-- whole bunch of code here
where
-- more bits and pieces
connect by prior x = y
start with z = 'VALUE'
I want to run this query on a whole set of values, resulting from using another select statement. I'm looking for something with similar semantics to:
start with z in (select * from ...)
I'm using an Oracle SQL databse here. There are so many varieties of SQL I find it hard to get something useful from a search, I wouldn't have thought the solution is all that complicated (?). The final query does not have to be necessarily efficient, it will be run only once.