Query Builder
The last SQL workshop module is the Query Builder. This module allows us to build a query on database table(s) using visual, graphical, and declarative means.
The Query Builder, like other similar tools, is often perceived as a tool for the novice user. This perception might be wrong. It's true that this tool can allow a complete novice to generate a fairly complicated query without much prior knowledge in SQL. However, an experienced user may also benefit greatly from this tool. Imagine you need to generate a SELECT statement on a 50 column table that includes several Foreign Key columns. Coding this statement manually can be very time consuming and tedious work, not to mention the possibility of irritable syntax errors and such. With the Query Builder, it can be a breeze.
The general layout of the Query Builder is similar to the Object Browser. On the left-hand side of the screen, we have a list of all the tables and views that are included in our APEX workspace schema(s...
