Page 286 - aREA ix eXHIBITS

7. Manage Data in 7.1 Date and Time in a Session’s Time Zone are compared in
Different Time accordance with PL/SQL framework
Zones 7.2 DBTIMEZONE and SESSIONTIMEZONE are described in
accordance with PL/SQL framework
7.3 The differences between DATE and TIMESTAMP are listed in
accordance with PL/SQL framework
7.4 The INTERVAL Data Types are identified in accordance with
PL/SQL framework
7.5 EXTRACT, TZ_OFFSET and FROM_TZ functions are used in
accordance with PL/SQL framework
7.6 TO_TIMESTAMP, TO_YMINTERVAL, and TO_DSINTERVAL
are used in accordance with PL/SQL framework
8. Retrieve Data 8.1 Pairwise and Nonpairwise are compared in accordance with
Using Subqueries PL/SQL framework
8.2 Scalar Subquery Expressions are used in accordance with
PL/SQL framework
8.3 Problems with Correlated Subqueries are solved in accordance
with PL/SQL framework
8.4 Correlated Subqueries are updated and deleted in accordance
with PL/SQL framework
8.5 The EXISTS and NOT EXISTS operators are used in accordance
with PL/SQL framework
8.6 The WITH clause is used in accordance with PL/SQL framework
8.7 The Recursive WITH clause is used in accordance with PL/SQL
framework

_________________________________________________________________________________ 31
TR – Programming (Oracle Database) NC III Promulgated – December 2013