Notes
Slide Show
Outline
1
 
2
Chapter 9
  • More SQL: Assertions, Views, and Programming Techniques
3
FIGURE 9.1
Two views specified on the database schema of Figure 5.5.
4
FIGURE 9.2
C program variables used in the embedded SQL examples E1 and E2.
5
FIGURE 9.3
Program segment E1, a C program segment with embedded SQL.
6
FIGURE 9.4
Program segment E2, a C program segment that uses cursors with embedded SQL for update purposes.
7
FIGURE 9.5
Program segment E3, a C program segment that uses dynamic SQL for updating table.
8
FIGURE 9.6
Importing classes needed for including SQLJ in JAVA programs in ORACLE, and establishing a connection and default context.
9
FIGURE 9.7
JAVA program variables used in SQLJ examples J1 and J2.
10
FIGURE 9.8
Program segment J1, a JAVA program segment with SQLJ.
11
FIGURE 9.9
Program segment J2A, a JAVA program segment that uses a named iterator to print employee information in a particular department.
12
FIGURE 9.10
Program segment J2B, a JAVA program segment that uses a positional iterator to print employee information in a particular department.
13
FIGURE 9.11
Program segment CLI1, a C program segment with SQL/CLI.
14
FIGURE 9.12
Program segment CLI2, a C program segment that uses SQL/CLI for a query with a collection of tuples in its result.
15
FIGURE 9.13
Program segment JDBC1, a JAVA program segment with JDBC.
16
FIGURE 9.14
Program segment JDBC2, a JAVA program segment that uses JDBC for a query with a collection of tuples in its result.
17
FIGURE 9.15
Declaring a function in SQL/PSM.