5. Database Access Using SQL

This chapter explains the use of the SQL database manipulation language to manipulate a database.

This chapter contains the following sections:

Organization of this chapter

5.1 Use of SQL in HiRDB

5.2 Basic data manipulation

5.3 Stored procedures and stored functions

5.4 Java stored procedures and Java stored functions

5.5 Triggers

5.6 Integrity constraints

5.7 Referential constraints

5.8 Check constraints

5.9 Check pending status

5.10 Improving database access performance

5.11 Narrowed search

5.12 Accessing databases using DB access products