Databases Reference
In-Depth Information
Figure 2-17.
An example of errors from the SQL Scripts interface
â–
although both the sQl Commands and sQl scripts interfaces can accept and run standard sQl statements,
the extended commands of sQl*plUs aren't valid in the tools.
Note
the sQl Commands interface throws an error when it encounters any sQl*plUs-specific commands. however, the sQl
scripts interface warns the user of the existence of sQl*plUs commands in a script being run and then ignores them if
the user chooses to continue. Because of this, the sQl Commands and sQl scripts interfaces can't perform many of the
functions of extended sQl*plus scripts.
The Query Builder
Although in 4.2 the Query Builder has been relegated to the Utilities page, it still appears as one of the icons in the
quick link bar at upper right on the page and merits discussion specifically because it's helpful to beginners. The
Query Builder is a utility that allows you to build SQL
select
statements using a more graphical interface, and
although it's not quite drag and drop, it's fairly intuitive.
When you first enter the Query Builder, you're presented with a screen that lists all the tables and views available
in the currently active schema. Figure
2-18
shows the initial Query Builder screen.
