Database Reference
In-Depth Information
Figure 8-47.
Resulting report generated from dynamic SQL
Note
The SQL statement uses a quoting syntax that you may not be familiar with.
Oracle Database 10g introduced a quoting mechanism for string literals that allows you
to define your own string delimiters, removing the need to double up single quotes in
strings. Any character can be used as a delimiter, including bracket combinations
()
{} [] <>
. The basic syntax is
q'X string X'
where
X
is any single character.
The
q'X
opens the literal string, and the
X'
closes the literal string. You can find more
details on the literal syntax in the
Oracle Database SQL Language Reference
.
Summary
As with any programming language or framework, learning the basics is the first step.
This chapter touched on a lot of points that could be considered tips of icebergs. Each
section has capabilities to reach into a vast set of technologies, with the Oracle data-
base being primary among them. The intention here is demonstrate how the APEX
framework works through the example application and to provide a starting point for
additional detail discovery.
