2. Details of Constituent Elements

This chapter explains in detail the constituent elements that are involved in the use of SQL.

This chapter contains the following sections:

Organization of this chapter

2.1 Cursor specification

2.2 Query expressions

2.3 Query specification

2.4 Subqueries

2.5 Table expressions

2.6 Table reference

2.7 Search conditions

2.8 Row value constructors

2.9 Value expressions, value specifications, and item specifications

2.10 Arithmetic operations

2.11 Date operations

2.12 Time operations

2.13 Concatenation operation

2.14 Set functions

2.15 Window function

2.16 Scalar functions

2.17 CASE expressions

2.18 Operational results with overflow error suppression specified

2.19 Lock option

2.20 Function calls

2.21 Inner derived tables

2.22 WRITE specification

2.23 GET_JAVA_STORED_ROUTINE_SOURCE specification

2.24 SQL optimization specification

2.25 CAST specification

2.26 Extended statement name

2.27 Extended cursor name

2.28 NEXT VALUE expression