5. Database Access Using SQL

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

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 C stored procedures and C stored functions

5.6 Triggers

5.7 Integrity constraints

5.8 Referential constraints

5.9 Check constraints

5.10 Check pending status

5.11 Improving database access performance

5.12 Narrowed search

5.13 Automatic numbering facility

5.14 Accessing databases using DB access products