Databases Reference
In-Depth Information
Figure 8-47.
Resulting report generated from dynamic SQL
Not
■
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 database 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.
