1 / 17

Chapter 9

Chapter 9. More SQL: Assertions, Views, and Programming Techniques. FIGURE 9.1 Two views specified on the database schema of Figure 5.5. FIGURE 9.2 C program variables used in the embedded SQL examples E1 and E2. FIGURE 9.3 Program segment E1, a C program segment with embedded SQL.

marrim
Download Presentation

Chapter 9

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Chapter 9 More SQL: Assertions, Views, and Programming Techniques

  2. FIGURE 9.1Two views specified on the database schema of Figure 5.5.

  3. FIGURE 9.2C program variables used in the embedded SQL examples E1 and E2.

  4. FIGURE 9.3Program segment E1, a C program segment with embedded SQL.

  5. FIGURE 9.4Program segment E2, a C program segment that uses cursors with embedded SQL for update purposes.

  6. FIGURE 9.5Program segment E3, a C program segment that uses dynamic SQL for updating table.

  7. FIGURE 9.6Importing classes needed for including SQLJ in JAVA programs in ORACLE, and establishing a connection and default context.

  8. FIGURE 9.7JAVA program variables used in SQLJ examples J1 and J2.

  9. FIGURE 9.8Program segment J1, a JAVA program segment with SQLJ.

  10. FIGURE 9.9Program segment J2A, a JAVA program segment that uses a named iterator to print employee information in a particular department.

  11. FIGURE 9.10Program segment J2B, a JAVA program segment that uses a positional iterator to print employee information in a particular department.

  12. FIGURE 9.11Program segment CLI1, a C program segment with SQL/CLI.

  13. FIGURE 9.12Program segment CLI2, a C program segment that uses SQL/CLI for a query with a collection of tuples in its result.

  14. FIGURE 9.13Program segment JDBC1, a JAVA program segment with JDBC.

  15. FIGURE 9.14Program segment JDBC2, a JAVA program segment that uses JDBC for a query with a collection of tuples in its result.

  16. FIGURE 9.15Declaring a function in SQL/PSM.

More Related