2
Basic Elements of Oracle SQL

This chapter contains reference information on the basic elements of Oracle SQL. These elements are the simplest building blocks of SQL statements. Therefore, before using the statements described in Chapter 8 through Chapter 17, you should familiarize yourself with the concepts covered in this chapter, as well as in Chapter 3, "Operators", Chapter 6, "Functions", Chapter 4, "Expressions", and Chapter 7, "SQL Queries and Other SQL Statements".

This chapter contains these sections:

• Datatypes

• Literals

• Format Models

• Nulls

• Pseudocolumns

• Comments

• Database Objects

• Schema Object Names and Qualifiers

• Syntax for Schema Objects and Parts in SQL Statements