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. That way I keep mu smaller queries as a PROJECT of the master query.
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. I have weekly CRITCAL report deadlines. Power Company
--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