Copyright 2004 Pearson Education Inc Chapter 9 More SQL Assertions Views and Programming Techniques Copyright 2004 Pearson Education Inc FIGURE 9 1 Two views specified on the database schema of Figure 5 5 Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 9 3 FIGURE 9 2 C program variables used in the embedded SQL examples E1 and E2 Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 9 4 FIGURE 9 3 Program segment E1 a C program segment with embedded SQL Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 9 5 FIGURE 9 4 Program segment E2 a C program segment that uses cursors with embedded SQL for update purposes Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 9 6 FIGURE 9 5 Program segment E3 a C program segment that uses dynamic SQL for updating table Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 9 7 FIGURE 9 6 Importing classes needed for including SQLJ in JAVA programs in ORACLE and establishing a connection and default context Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 9 8 FIGURE 9 7 JAVA program variables used in SQLJ examples J1 and J2 Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 9 9 FIGURE 9 8 Program segment J1 a JAVA program segment with SQLJ Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 9 10 FIGURE 9 9 Program segment J2A a JAVA program segment that uses a named iterator to print employee information in a particular department Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 9 11 FIGURE 9 10 Program segment J2B a JAVA program segment that uses a positional iterator to print employee information in a particular department Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 9 12 FIGURE 9 11 Program segment CLI1 a C program segment with SQL CLI Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 9 13 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 Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 9 14 FIGURE 9 13 Program segment JDBC1 a JAVA program segment with JDBC Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 9 15 FIGURE 9 14 Program segment JDBC2 a JAVA program segment that uses JDBC for a query with a collection of tuples in its result Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 9 16 FIGURE 9 15 Declaring a function in SQL PSM Elmasri and Navathe Fundamentals of Database Systems Fourth Edition Copyright 2004 Pearson Education Inc Slide 9 17
View Full Document
Unlocking...