O'Reilly logo

Oracle Application Express 3.2 by Matthew Lyon, Arie Geller

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required