1 / 9

Announcements

Announcements. Reading for next week: Chapters 6 and 7 Next-to-Last reading from the text for a little while (I promise) Your database accounts should be ready now See me if you have any trouble accessing your accounts Your first homework will be posted on the website tonight

lloyd
Télécharger la présentation

Announcements

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. Announcements Reading for next week: Chapters 6 and 7 Next-to-Last reading from the text for a little while (I promise) Your database accounts should be ready now See me if you have any trouble accessing your accounts Your first homework will be posted on the website tonight Please pick a partner (or 2) for your class project One person from each team send me an email by next class, cc’ed to the other members of the team.

  2. Advanced SQL Topics Oracle Tools SQL*Plus (and Worksheet) SQL*Loader Domain Types Integrity Constraints Authorization Embedded and Dynamic SQL Stored Procedures The Limits of SQL

  3. Advanced SQL Topics Oracle Tools Domain Types Basic: CHAR, VARCHAR, INT, DOUBLE, etc. Date, Time, and Timestamp User-defined types Large OBject (LOB) types: CLOB and BLOB Integrity Constraints Authorization Embedded and Dynamic SQL Stored Procedures The Limits of SQL

  4. Advanced SQL Topics Oracle Tools Domain Types Integrity Constraints Basic: Primary Key, not null, unique check clause, assertions Foreign Key Authorization Embedded and Dynamic SQL Stored Procedures The Limits of SQL

  5. Advanced SQL Topics Oracle Tools Domain Types Integrity Constraints Authorization Grant, Revoke Users and Roles Embedded and Dynamic SQL Stored Procedures The Limits of SQL

  6. Advanced SQL Topics Oracle Tools Domain Types Integrity Constraints Authorization Embedded and Dynamic SQL EXEC SQL/END SQL (C style embedding) #SQL { } (Java style embedding) ODBC and JDBC Stored Procedures The Limits of SQL

  7. JDBC Example import java.sql.*; // and maybe javax.sql.*; public static void JDBCexample(String dbid, String userid, String pw) { try { Class.forName(“oracle.jdbc.driver.OracleDriver”); Connection conn = DriverManager.getConnection( “jdbc:oracle:thin:@oracle2.cis.temple.edu:tempdb”, userid, pw); Statement stmt = conn.createStatement(); try { stmt.executeUpdate( “insert into student values(‘jim’,200,’phd’,’zoran’)”); catch(SQLException sqle) { … } stmt.close(); conn.close(); } catch(SQLException sqle) { … } }

  8. Advanced SQL Topics Oracle Tools Domain Types Integrity Constraints Authorization Embedded and Dynamic SQL Stored Procedures Why Stored Procedures? The Basics of Stored Procedure Syntax The Limits of SQL

  9. Advanced SQL Topics Oracle Tools Domain Types Integrity Constraints Authorization Embedded and Dynamic SQL Stored Procedures The Limits of SQL What can’t be done with SQL that can be done with Java/C/C#/other programming languages? Recursive SQL – solution? Event-based programming?

More Related