Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is it possible to chain queries?

Tony DunsworthMay 6 2011 — edited May 9 2011
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
This post has been answered by Frank Kulash on May 6 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 6 2011
Added on May 6 2011
17 comments
1,164 views