Is it possible to chain queries?
I'm working on an application which needs to work as an ASP.NET web page. To filter the data I need down to the final queries, right now, I have 3 queries which get me down to the needed queries. Is there a way in PL/SQL to package the first three queries so they can be run in sequence then grab the result into a view (Don't have table creation abilities, thinking I will have to talk to the admin on this.) which my final 2 queries can access. The first three queries run off of each other and I use create views for them when I'm doing this on the fly in sqldeveloper. The final two actually return the data the end user wants to see and what would have to appear on the webpage. I've read tutorials and PL/SQL books and feel just as confused as when I started, so trying to get a little push in the right direction then figure it out on my own.
Thanks in advance,
If I've not been clear enough, can include copies of the queries, etc. (The first one, right now, works with three tables and I create a view from it which the next query accesses, and so on.)
Tony