Thanks for the question, Ron.
Asked: November 18, 2015 - 8:09 pm UTC
Last updated: November 19, 2015 - 3:55 am UTC
Version: Latest
Viewed 1000+ times
You Asked
New to Oracle SQL Developer.
--Using the SQL Query Builder, can you treat two or more queries as a saved database PROJECT? In other words, (similar to MS Access), can you build smaller queries and then use those queries as sub queries WITHIN the saved Oracle database project to build a master/final query in a graphical view. Clarification, this is using the SQL Query Builder.
Haven’t found any GOOD technical documentation that specifically explains this. Right now, I can only do single queries.
--Easy way to convert established MS Access queries to Oracle SQL Developer.
I hope to gain the following benefits migrating to Developer (particularly SQL Query Builder):
--More robust in handling BIG DATA than MS Access. Therefore, you are able to design reports/databases much quicker.
--If you need to Directly make modifications to the SQL code, you are only worried about the specific modification and NOT designing the entire primary code.
--Better suited for SharePoint report deployments.
Thanks a bunch,
Ron
and Connor said...
Is this answer out of date? If it is, please let us know via a Comment