Skip to Main Content
  • Questions
  • How to use Query Builder in SQL Developer

Breadcrumb

Question and Answer

Connor McDonald

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...

Here's a nice intro video to Query Builder

http://www.thatjeffsmith.com/archive/2014/03/oracle-sql-developer-query-builder-video-demonstration/

but yes, my understanding is that its primarily designed as a graphical means of building queries, not as means of building an "application" or suite of queries

In terms of migration of queries, check out View => Migration Projects in SQL Developer

http://www.thatjeffsmith.com/archive/2011/06/moving-data-to-oracle-with-migration-workbench/



Is this answer out of date? If it is, please let us know via a Comment