Oracle Programming

Rajshekhar Sunderraman is an assistant professor of mathematics and computer science at Georgia State University in Atlanta. Professor Sunderraman received his Ph.D. in computer science from Iowa State University and has been teaching computer science for more than 10 years. He has published numerous articles on a wide range of topics, including inconsistencies in relational databases, negation in deductive databases, and declarative specification of objects in object-oriented databases. 0201357534AB04062001

1. The Relational Model Relational Database.


Integrity Constraints.



Tabular View of a Relation.



Sample Databases.



Relational Algebra.



2. Oracle SQL Oracle SQL Plus.


Creating, Dropping and Altering Tables.



Inserting Rows.



Querying the Database.



Views.



Modifying the Database.



Sequences.



Oracle Data Dictionary.



3. Embedded SQL Host Variables.


Indicator Variables.



SQL Communications Area.



Connecting to Oracle.



Cursors.



Mail Order Database Application.



Recursive Queries.



Error handling.



Transaction Control.



Dynamic SQL.



4. PL/SQL What is PL/SQL.


Datatypes and Variables.



Program Control Statements.



Program Structure.



Triggers.



Database Access using Cursors.



Records.



PL/SQL Tables.



Built-In Packages.



Error Handling.



5. Oracle JDBC What is JDBC.


A Simple Exercise.



Developing JDBC Applications.



Non-Query SQL Statements.



Executing SQL Queries.



A Complete Example.



Database Metadata.



Errors and Warnings.



6. Projects Airline Flight Information Systems.


Library Database Application.



University Student Database.



Video Chain Database.



Banking Database.



BibTeX Database.



Music Store Database. 0201357534T04062001