2. Database Operations

This chapter explains the data expressions used in a database and provides examples of basic database operations.

The SQL statements used in the examples are excerpts from the complete SQL statements written according to the prescribed syntax; for details about SQL statements, see the HiRDB Version 8 SQL Reference manual.

This chapter contains the following sections:

Organization of this chapter

2.1 Database data expressions

2.2 Cursor usage

2.3 Data retrieval

2.4 Data updating

2.5 Data deletion

2.6 Data insertion

2.7 Specific data search

2.8 Data operations

2.9 Data processing

2.10 Outer joining of tables

2.11 Defining and manipulating a view table

2.12 Manipulating data in a table with abstract data types