1. Basics

This chapter explains the basics of using SQL. It contains the following sections:

Organization of this chapter
1.1 SQL coding format
1.2 Data types
1.3 Character sets
1.4 Literals
1.5 USER, CURRENT_DATE value function, CURRENT_TIME value function, and CURRENT_TIMESTAMP value function
1.6 Embedded variables, indicator variables, ? parameters, SQL parameters, and SQL variables
1.7 Null value
1.8 Component specification
1.9 Routines
1.10 External routines
1.11 Specifying a datetime format
1.12 Restrictions on the use of the inner replica facility
1.13 Locator
1.14 XML type
1.15 XQuery