PART 1. Working with Databases
Previous chapters have described SQL statements as you execute them in Interactive SQL or in some other interactive utility.
When you include SQL statements in an application there are other questions you need to ask. How are query result sets handled in your application? How can you make your application efficient?
While many aspects of database application development depend on your application development tool, database interface, and programming language, there are some common problems and principles. These are discussed in this chapter.
Executing SQL statements in applications
Introduction to cursors
Types of cursor
Working with cursors
Describing result sets
Controlling transactions in applications